Get text gives me thousand separator with coma and I need it with dot

Help Studio
1

So im scraping prices and then writing it to my excel sheet.
The problem is my excel has thousand separator with dot and decimal separator with comas.

But the get text and write cell activities give me the number with thousand separator with coma and decimal separator with dot.

How can I transform the number so it is places with thounsand separator with dot and decimal separator with coma?

image

2

HI,

How about using Replace method as the following?

PR.Replace(",","_").Replace(".",",").Replace("_",".")

This assumes there is no _ in the string.

Regards,

2 Likes
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.