Import Error

Highlighted
Contributor

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.

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: Import Error

@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.

2019-07-03_15-52-15.png

I hope this helps

Good luck

David

Highlighted
Contributor

Re: Import Error

Hi David,

Thanks for the fast reply.

Put the Text Demiliter to None and it worked!

Thanks again,
Hendrik
Highlighted
Master Anaplanner/Community Boss

Re: Import Error

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