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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Number formatting with commas in data extraction

hilarylester
Level 1
Level 1

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!

2 Replies
Vapsy
Employee
Employee

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

hilarylester
Level 1
Level 1

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