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

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):

This is the specs file:

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

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

Thank you

1 Like

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

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

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