Import date enclosed in double quotation

hyudolee
hyudolee
in Integrations and extensibility

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

 

Tagged:

Answers

  • Anurag0911
    Anurag0911

    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
    ryan_kohn

    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.

Categories