Double quotation marks got inserted when importing a list | Adobe Higher Education
Skip to main content
alik98709228
alik98709228
Level 2
May 27, 2021
Risolto

Double quotation marks got inserted when importing a list

  • May 27, 2021
  • 3 risposte
  • 1284 visualizzazioni

Hello,

 

I am importing a txt file/list with the following values:

 

digital_values

12,000

10,000

 

But system is inserting double quotation marks when I finish importing and the data looks like this:

digital_values

"12.000"

"10,000"

See attached screenshot as well. How do I prevent this?

Any idea?

 

Thanks!

 

AK

Questo argomento è stato chiuso alle risposte.
Migliore risposta di CedricRey

Hello AK,

 

I don't know how you import the file, but usually, with standard import, you have to setup it.

 

First, when you setup the imported file you can use the auto detection functionality.

The, , you'll find a link like "Click here to change the file format".

Select you column 'digital_values', and change the data type to put it in number and not string.

Also, if your file has headers, check the option for it.

 

Cédric

3 risposte

CedricRey
CedricReyRisposta
Level 5
May 27, 2021

Hello AK,

 

I don't know how you import the file, but usually, with standard import, you have to setup it.

 

First, when you setup the imported file you can use the auto detection functionality.

The, , you'll find a link like "Click here to change the file format".

Select you column 'digital_values', and change the data type to put it in number and not string.

Also, if your file has headers, check the option for it.

 

Cédric

    D
    DebTr
    Level 6
    May 28, 2021

    Hi @alik98709228 ,

    I guess you are using a data loading activity here.

    When you set it up by default it sets the data type as string and hence you are seeing double quotes.

    If the "Auto-detect Format" doesn't work you need to click on "click here to change the file format"(as mentioned by Cedric) and change the data type as required.

     

    Thanks,

    Deb

      Sukrity_Wadhwa
      Community Manager
      Sukrity_WadhwaCommunity Manager
      Community Manager
      June 10, 2021

      Hi @alik98709228,

      Were you able to resolve this query or do you still need more help here? Do let us know.

      Thanks!

      Sukrity Wadhwa
      Termini e CondizioniAccessibility statement

      Loading footer...