Parsing

[olehr]

Hi there, 

I have a file containg data on sales accross different categories.  However, I need to parse it as it is given in the following format:  As you can see, this is a bit hard to work with :p  Does anyone have any suggestions ?  

I appreciate any help I can get. 

Kind regards

[neilgallen]

@olehr Can you provide an example of what your desired output is? That will determine how to best go about parsing the input.

[JeroenJacobs · Accepted solution]

Hi olehr,

I think there's a fairly simple solution to your problem, just add a Data Cleansing tool where you remove letters and whitespace and a select tool where you change the type to an integer.

Good luck!

Jeroen

[olehr]

Thanks, 

I do not know why I did not think of the Data-Clensing tool.  Thanks for the reminder!

Kind regards.