web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Data with comma using ...
Microsoft Dynamics AX (Archived)

Data with comma using CSV in DMF

(0) ShareShare
ReportReport
Posted on by Freya Tan 935

Hi Guys,

I'm having an issue importing data with comma using DMF. I am using a CSV file to import it. Though the text with a comma is enclosed in a double qoute, it doesn't process correctly. I already tried to use a pipe delimiter, but it doesn't works also.

Any ideas?

thanks.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,670 Super User 2025 Season 2 on at
    RE: Data with comma using CSV in DMF

    Did you also check all options in your Source data formats? You can set delimiters for: Row, Column, Multi value and Chart of Accounts (Dimensions). Are these values unique or do some fields have the same setting?

    Be sure if you are using the Comma or Pipe that the data itself does not contain these values.

  • Verified answer
    skaue Profile Picture
    skaue Moderator on at
    RE: Data with comma using CSV in DMF

    I would highly recommend using Tab as Column delimiter, instead of comma. It just makes it easier to copy + paste between text and Excel, plus it is less prune to troubles around commas inside a column value. Sure, quations should handle that, but still

    Second thing you need to double check is the codepage being used.

    I recommend downloading the free Notepad++ (notepad-plus-plus.org/download) or some other similar text editor. Notepad++ has a menu where you can check the text files current codepage and simply convert it from UTF+8 to ANSI or the other way around (as an example).

    You may very well open the file in Notepad (regular) and it looks good, but the import program will not automatically evaluate the codepage being used, and this may result in a failed analyzis of the file during import.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans