Using CSV parser in a TXT File.

[emoreira]

Hello All,

I am trying to use the CSV parser to parse a text but I keep getting the Out of Bounds error. Can anybody help me here?

Here is how myfile looks like: no headers and collums separated by space:

Tried also to replace the spaces by "|", but no success.

Here is my CSV Parser Call

I am pretty sure I am not supposed to leave the "space" between the double quotes, but it also did not work for "|" so I am missing something else.

Any thoughts?

Cheer

Ewerton

[CarlesColl]

Hi Ewerton,

Few things:

• columnMappings should have the same number of colums as dataShape
• The last line on the CSV file should be an empty line
• Decimal Delimiter should be "." instead of a "," --> We have a customized CSVParser version in order to support it, but with the default CSVParser exension you are out of luck

Best Regards,

Carles.

[emoreira]

Thanks!

[Abhiram]

Hi Carles,

What is that customized CSVParser?? Can I get that extension in market place?

Thanks!

[CarlesColl]

Is this one on the marketplace: ThingWorx IoT Marketplace

[Abhiram]

Thanks, I tried with this extension but still I'm getting array out of bound exception because of that CRLF.

Any other wayto handle this??