Using CSV Buffer with Text Qualifier

(0) Share

Report

Posted on by MHalton

I am importing Customer data using the CSV Buffer in my codeunit.

My file field separator is comma. However, in some of my customer names, there is a comma (Company Name, INC for example). Those fields have quotes as the text qualifier but I don't see where I can indicate that when using the CSV Buffer codeunit.

Any help would be appreciated.

- Melissa

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

I don't think we have that option in the CSV buffer. I could not find it either.

So i think you have to read your stream line by line and parse them manually.

You can probably also consider to convert your file before you import it to BC.

Was this reply helpful? Yes No