Splint a string of data into columns based on number of spaces

KNIME Analytics Platform
#1

Greetings,
I am new to this application and still learning and having fun with it. I am stuck on this data challenges issue with a file format called CALinx used for pharmacy data. The file is NOT delimited and does NOT have headers. I need to be able to break each row to columns based on the number of right arrow on the keyboard. Let me give an example (not real patient info):

Capture
Capture946×55 15.7 KB

This is the specs file:

specs
specs519×764 103 KB

so after doing this manually, this is how it should look like:

after
after1387×86 36.7 KB

I have tried the Cell Splitter node, but it did not do the job. Please help!

Thank you

1 Like
#2

Hi @hyousef1 and welcome to the forum.

This sounds like a job for the Fixed Width File Reader node… can you give that one a shot?

5 Likes
#3

OMG Scott, That totally did it. Thank you so much for your prompt response. I am loving this application and the community support.

2 Likes
#4

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.