Import Error

Dear,

Whilst importing a .txt file into the Datahub we encounter the error 'unmatched delimiter character at line 100968 character 17'.

Tried looking in the datafile and erasing the datarow and uploading again but nonetheless we have the same problem.

Hope somebody can help.

Accepted answers

DavidSmith

@HendrikDeCuyper

I had this issue a while ago

The problem I had was that there was a delimiter (in my case a comma) within the description of the fields. What was happening was the import then parsed and it was looking for the "end" but couldn't find it so it errored

Have a look at the Text delimiter settings on the import tab, or try and use a different delimiter.

I hope this helps

Good luck

David

All comments

DavidSmith

@HendrikDeCuyper

I had this issue a while ago

Have a look at the Text delimiter settings on the import tab, or try and use a different delimiter.

I hope this helps

Good luck

David

HendrikDeCuyper

Hi David,

Thanks for the fast reply.

Put the Text Demiliter to None and it worked!

Thanks again,
Hendrik

DavidSmith

Excellent

It took me about 4 hours to find it as my file was about 10 million rows. I worked from the bottom up, splitting the file in half each time

The error was in row 100!!!

David

LilyLiuAnaplan

Hi David & Our Anaplan Experts,

@DavidSmith Thank you so much for this article - it saved me a lot of time as I went straight with searching for double quote.

My issue is that I do need to use delimiter for my nightly automated load using Anaplan Connect. I have little control at the moment to prevent my users from entering a " or ', which will end up in our load file.

I know we probably need to solve this issue at the data source but is there anything we can do to mitigate this issue (e.g. automatic scan this records) without restricting user input?

Thank you so much,

Lily

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385