Import: Mapping Issue with Tab Separators

Hi all,

When I tried to upload .csv file with Tab separator, I cannot see any mapping with setting (Please refer to the file called "Separtors=Tab.PNG") and import went to be failed.

With Column separator, however, I could see what items were mapped (Refer to the the file "Separators=Column.png).

The difference between those files are only the separator.

Could anyone can tell me why these difference is occurred and how to solve the issue with Tab separator?

Thanks

Separatos=Tab_76718.PNG

Separators=Column_76718.png

Accepted answers

All comments

nathan_rudman

what do you call column separator ?

Open your file with Notepad++ and display the special characters, you'll see if you have an issue in there

MaoNinomiya

@nathan_rudman

Thanks for your quick response.

>Open your file with Notepad++ and display the special characters, you'll see if you have an issue in there

I'll check.

Are you saying that tab separator won't work if there is any special characters in column (or maybe rows)?

Mao Ninomiya

nathan_rudman

no, but you might have a tab somewhere in the data that pushes all the mapping one or two columns, although that wouldn't be for all lines.

I don't understand what you mean by separator = column so I'm asking you to check what exactly you have in your file as a separator. It seems it is not tab.

MaoNinomiya

Sorry for making you misunderstand. separator = column means “Separator=Commma”.

abhay.kanik

@MaoNinomiya I think you are trying to import a tab delimited file with configuration of comma separated file.

I Suggest you to check this config once.

Screenshot 2020-07-13 at 2.52.20 PM.png

MaoNinomiya

By fixing text delimiter setting in File Option, the file was imported successfully.

Thanks to @abhay.kanik and @nathan_rudman for helping me solve the issue.

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