Export Bot - thousands comma issue

[StephenSaid]

I have a bot that exports a CSV file.

When I have quantity greater than 1,000, the comma indicating the thousand gets interpreted as another field in the CSV. How can I eliminate this comma?

Template:

cBatchNo,cBatchDescription,iTrCodeID,iStockID,iFromWhseID,iToWhseID,fQuantity,cReference,cDescription
<<Start:SELECT([Related Transfers][Row ID],[QtyCheck]>0)>><<[BatchNumber]>>,<<[TransferNumber]>> (App),WHT,<<[Item Code]>>,<<[WarehouseFromCode]>>,<<[WarehouseToCode]>>,<<[QtyCheck]>>,Submitted by: <<[Name]>>,Processed by: <<[ProcessedByName]>>
<<End>>

[Markus_Malessa · Accepted solution]

Something to try that I did not test myself, but maybe use the SUBSTITUTE() function for each number or decimal column:

<<SUBSTITUTE([NumberOrDecimalColumn], ",","")>>

[MultiTech]

I believe the official solution is to encapsulate the number in double quotes when you're exporting the CSV.

<<Start:SELECT([Related Transfers][Row ID],[QtyCheck]>0)>>
<<[BatchNumber]>>,<<[TransferNumber]>> (App),WHT,<<[Item Code]>>,<<[WarehouseFromCode]>>,<<[WarehouseToCode]>>,"<<[QtyCheck]>>",Submitted by: <<[Name]>>,Processed by: <<[ProcessedByName]>>
<<END>>