Weird Character in fist column of .csv import

jasnyder1973

I have been noticing on some .csv imports weird characters appearing in the first column of the .csv

When I open in excel or text editor the characters are not there.

Additionally, I seem to be seeing this quite a bit with exports directly from Anaplan.

Accepted answers

All comments

Misbah

@jasnyder1973 Which Text encoding option are you using while import?

andrewtye

Agree... back in the day had to be very careful about CSV file format. Often found that a manual download from a system would have a slightly different one to an automated one.

If you were to reimport the file brand new (ie call it something else) then the issue should go away.

jackyjoy123

thanks for the awesome information.

https://creditcardsupportx.com/burlington-credit-card
https://creditcardsupportx.com/zulily-credit-card
https://creditcardsupportx.com/american-eagle-credit-card

MarkWarren

Sticking to UTF-8 is safest.

naveenmaurya

During the exports of .csv format, there were a lot of these characters coming for me too. I tried this option in the export definition and it works quite well.

jasnyder1973

I was using .xls with formatting...I think that I will drop that going forward and take suggestions below.

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…