Text to column

Hi, I have following data, out of which I just need Order Number (129*) and Part cost ($) in columns.

Please suggest the solution. I have tried Cell Splitter with delimiter as Space, but it is not working.

Thanks

Welcome to the forum, @riteshmakkar.

What format is your data originally?
What node are you using to read the data?
Can you share the data file?

4 Likes

is the delimiter really a space or rather one or more tabs? looks like pdf table? if it’s a text file you might want to have a look at the line reader

Hi, Its a text file which I copied and pasted in excel to read further in Knime.
I am using excel reader to read the file and further trying to use Cell Splitter.

But space between text is not the same, so cell splitter is unable to perform the required job.

Tried to use Line reader. It’s unable to read data. Giving outcome as following in all the encoding formats.

Its a text file which I copied and pasted in excel to read further in Knime.
I am using excel reader to read the file and further trying to use Cell Splitter.

Why did you copy and paste it into Excel?
Can you share the text file?