Importing a file without delimiters

(0) Share

Report

Posted on by SKO

297

I am trying to import a file without delimiters and its a transaction file with one long string having divided by 120 characters. I could not handle it through code as AX supports only string size of 65000 characters. I have used the commaio class but it does not read all the data and randomly reads only a portion of data.

Any help is appreciated.

Thanks

*This post is locked for comments

All responses (3)

Answers (2)

Verified answer

Mea_ 60,278 on at

Like (0)

Report

RE: Importing a file without delimiters

So you can read file to a string now.

Use https://msdn.microsoft.com/en-us/library/aa677836.aspx in a loop to split it.
SKO 297 on at

Like (0)

Report

RE: Importing a file without delimiters

Hi Ievgen,

Amazing!!!! It works.

But i have more requirement like my import file is of type simple text file and it has transactions in it. All the transactions are loaded without any delimiters and i have to read the transactions by breaking them to 120 characters each.

Can you please help me
Verified answer

Mea_ 60,278 on at

Like (0)

Report

RE: Importing a file without delimiters

Hi Srikanth,

You can try to use System.IO.StreamReader mycsharpdeveloper.wordpress.com/.../how-to-read-text-file-line-by-line-in-ax