Hello everyone,
Im new to Alteryx and I inherited some code that doesnt quiet work and ive been hinted that it can be fixed with RegEx. To make it simple, I jave a column where the amounts are all over the place in terms of formating. Here is an example
1648.90
375,974.8
390
80,02
748.274,74
2.785.379
0,01
All this should be converted to number with " , " for thousands and " . " for decimals.
Any ideas?
Thanks in advance
@bguenzatti
I happened to answer one similar question, maybe you can take a look first?
Are you certain this is correct since there are two periods there?
2.785.379