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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

DIEF CSV import not parsing Smart (curly) quotes correctly

(0) ShareShare
ReportReport
Posted on by 204

When importing a csv file via DIEF, I kept getting an error that the delimiter for my last column was missing.  After digging into it, i found that the previous columns data contained 3 quotation marks that were of the 'curly' nature.  It seems that the DIEF process treated these "smart" quotes as regular quotes instead of ignoring them like it is supposed to.  I tried looking in the DIEF source data format settings, but didnt see anything helpful in there. The solution was to do a find and replace all smart quotes with straight quotes.  When converting the excel sheet to CSV, excel then surrounds the straight quotes with more quotes, and this will import into DIEF just fine then.  

Just curious if anyone else has run into this issue before and if there is any other solution at a code level within DIEF.

*This post is locked for comments

I have the same question (0)

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans