Import date enclosed in double quotation

hyudolee
Occasional Contributor

Import date enclosed in double quotation

Hi, I want to import csv file.

But the data was enclosed by double quotation in text file.

 

Are there any problems when I import this type of csv file?

 

hyudolee_0-1658989733003.png

 

2 REPLIES 2
Anurag0911
Contributor

Not as long as you set the right data types all these should be in text formatted line items then you can covert them to numbers on Anaplan. 
CSV is nothing but comma-separated values you can import anything as long you are using the right formats.
If you still face any issues feel free to do so here.

ryan_kohn
Certified Master Anaplanner

You can configure the structure of the import file in the first step of the import process. See here for more information: https://help.anaplan.com/8d55fc47-e743-4630-b619-2481fa8645ae-Import-data-into-modules-from-a-file

 

Note the option for Text Delimiter can be double quotes.

 

By the way, in your screenshot, it looks like the date is missing a starting quotation mark, so you'd probably get an error when trying to import the data.