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

Avatar

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

Avatar

Employee Advisor

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

Level 1

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