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)

Sort by

Verified answer

Martin Dráb 239,069 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

Hi Martin,

We are using TextIO now.

Regards,

Akbar

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,069 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Akbarpasha on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No