Parsing the Details

[chandr45]

Hello Team,

I am trying to parse the details, but i am failing to use the tool. The tool is not parsing the properly. I browsed the help in the community section, those are very simple to work out.

Please help.

Best,

[cmcclellan · Accepted solution]

I can feel your pain :) 

It's not a CSV file, and doesn't have a single delimiter at all (not even a tab).  The other big problem is that the file changes formats at line 60 because the first column is suddenly wider and throws out all the numbers.

What I've attached is NOT complete, it's just a start in how I would tackle it.

It would be better (if possible) to go back to the data provider and ask for a CSV or similar format where the column widths don't change.

You can remove the multi-field formula in my container, I had to do that to convert the string to a number.  You might need it to get rid of the comma.

[chandr45 · Accepted solution]

Thank you cmcclellan, I managed to complete the task. I did check with the data provider, it is the PDF converted CSV, that's the reason.

Best,