How to read value having comma(,) in the column while reading CSV file - AX 2009

(0) Share

Report

Posted on by Akbarpasha

Hi All,

We are trying to read one column from CSV file having comma(,) in the value like "Abc,def" , but while reading this column it is dividing into 2 columns like "Abc" and "def" instead one value like Abc,def.

Any solution to avoid this type of issue, please advice us.

Regards,

Akbar

All responses (4)

Answers (2)

Akbarpasha on at

Like (0)

Report

RE: How to read value having comma(,) in the column while reading CSV file - AX 2009

Thank you Martin, we have used CommaTextIo class and able to read the correct values.
Verified answer

Martin Dráb 233,019 Most Valuable Professional on at

Like (0)

Report

RE: How to read value having comma(,) in the column while reading CSV file - AX 2009

That's likely the problem. Please try my suggestion.
Akbarpasha on at

Like (0)

Report

RE: How to read value having comma(,) in the column while reading CSV file - AX 2009

Hi Martin,

We are using TextIO now.

Regards,

Akbar
Verified answer

Martin Dráb 233,019 Most Valuable Professional on at

Like (0)

Report

RE: How to read value having comma(,) in the column while reading CSV file - AX 2009

How are you doing it at the moment?

What if you use CommaTextIo (if it exists in AX 2009) or CommaIo?