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

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Martin Dráb 237,985 Most Valuable Professional on at

Like (0)

Report

How are you doing it at the moment?

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

Was this reply helpful? Yes No
Akbarpasha on at

Like (0)

Report

Hi Martin,

We are using TextIO now.

Regards,

Akbar

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,985 Most Valuable Professional on at

Like (0)

Report

That's likely the problem. Please try my suggestion.

Was this reply helpful? Yes No
Akbarpasha on at

Like (0)

Report

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

Was this reply helpful? Yes No