Workaround to save comma separated number in csv without quotes

UI.Vision RPA General Discussion
1

Hi All,

I am facing an issue with exporting comma separated numbers in CSV format
Of the below numbers, except last one, all numbers save without quotes:
£224.54
£158.83
£4.10
£140.04
£657.80
“£18,958.80”

Is there a workaround to fix this?
I am happy with removing the comma from the number before saving to the csv file.
Or are any other file formats supported other than csv to export data from Kantu?

Cheers,
Aravind

2

all numbers save without quotes:

Yeah. The last number has “” because they are needed because of the comma inside the string.

Question: Do you want “” everywhere? Or no “” at all?

If no “” at all: Removing the comma from the string should solve it.

Or are any other file formats supported other than csv to export data from Kantu?

This is on our todo list.

3

Thanks for the response. Can you please explain how I get this done in Kantu - “Removing the comma from the string should solve it.”

4

Can you please share any sample macro/pseudocode for this?