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

Number formatting with commas in data extraction

Avatar

Avatar
Level 1
hilarylester
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
hilarylester
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
hilarylester
Level 1

30-04-2018

Using the "Data Extraction (file)" activity, how do I export a field in a file formatted as an integer with commas (ie: 50,000 instead of 50000)? Thanks in advance!

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

369 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

369 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

03-05-2018

On the export form where you select Destination format please click on the Edit button against Number format and enable "Separate thousands"

1479444_pastedImage_0.png

Sorry I've not been able to locate how to use comma for this.

Regards,
Vipul

Avatar

Avatar
Level 1
hilarylester
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
hilarylester
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
hilarylester
Level 1

14-05-2018

This function only inserts space between each thousand, I don't see options to insert commas. Please advise.