Export Bot - thousands comma issue

AppSheet AppSheet Q&A
,
1

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

StephenSaid_0-1709291906496.png
StephenSaid_0-1709291906496.png1182×1294 111 KB

2

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

<<SUBSTITUTE([NumberOrDecimalColumn], ",","")>>
1 Like
3

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