Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Double quotation marks got inserted when importing a list

Avatar

Avatar
Give Back
Level 2
alik98709228
Level 2

Likes

3 likes

Total Posts

27 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
Boost 3
Boost 1
View profile

Avatar
Give Back
Level 2
alik98709228
Level 2

Likes

3 likes

Total Posts

27 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
Boost 3
Boost 1
View profile
alik98709228
Level 2

26-05-2021

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Avatar

Avatar
Affirm 25
Level 4
Deb007
Level 4

Likes

50 likes

Total Posts

86 posts

Correct Reply

25 solutions
Top badges earned
Affirm 25
Boost 25
Applaud 5
Give Back 5
Validate 1
View profile

Avatar
Affirm 25
Level 4
Deb007
Level 4

Likes

50 likes

Total Posts

86 posts

Correct Reply

25 solutions
Top badges earned
Affirm 25
Boost 25
Applaud 5
Give Back 5
Validate 1
View profile
Deb007
Level 4

28-05-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

Avatar

Avatar
Boost 10
Level 3
CedricRey
Level 3

Likes

24 likes

Total Posts

62 posts

Correct Reply

11 solutions
Top badges earned
Boost 10
Applaud 5
Boost 5
Affirm 5
Give Back
View profile

Avatar
Boost 10
Level 3
CedricRey
Level 3

Likes

24 likes

Total Posts

62 posts

Correct Reply

11 solutions
Top badges earned
Boost 10
Applaud 5
Boost 5
Affirm 5
Give Back
View profile
CedricRey
Level 3

27-05-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

Avatar

Avatar
Validate 1000
Employee
Sukrity_Wadhwa
Employee

Likes

140 likes

Total Posts

856 posts

Correct Reply

35 solutions
Top badges earned
Validate 1000
Validate 500
Validate 250
Validate 100
Validate 25
View profile

Avatar
Validate 1000
Employee
Sukrity_Wadhwa
Employee

Likes

140 likes

Total Posts

856 posts

Correct Reply

35 solutions
Top badges earned
Validate 1000
Validate 500
Validate 250
Validate 100
Validate 25
View profile
Sukrity_Wadhwa
Employee

10-06-2021

Hi @alik98709228,

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

Thanks!