cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

Using CSV parser in a TXT File.

emoreira
12-Amethyst

Using CSV parser in a TXT File.

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

5 REPLIES 5

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.

Thanks!

Hi Carles,

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

Thanks!

Is this one on the marketplace: ThingWorx IoT Marketplace

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??

Top Tags