Hi, new user here, so please be patient 
I have a couple of Excel files which (since my locale is German) have the comma as the digit separator (e.g. 25,6).
How can I transform those to 25.6 which is what I need?
I want to stack the files but also clean them up at the same time.
Thanks for any help!
I have sometime the opposite one, get logging files with . and want to have the (German) “,”
I just use the Replace transformation, select all number columns and change “,” to “.” or vice versa. If the value is already correct the replace will do nothing.
1 Like
You can change the locale in Preferences. But probably better to use Replace, as suggested by @Olaf.
replace-comma.transform (1.4 KB)
Many thanks to @Olaf and @Admin (Andy) for the speedy reply!
One more question: Can I swap columns? I would like to swap columns 3 and 4.
Yes, use the Reorder Cols transform.
https://www.easydatatransform.com/help/latest/windows/html/index.html?reorder.html
Not seeing the forest for the trees… Thanks a bunch!
All the different transforms can be a bit overwhelming at first. But hopefully you will soon get used to them. Note that you can type keywords to find transforms in the left pane:
1 Like