CSV comma as decimal separator

[Carl2]

Hi

I am a total beginner but rapidly increasing my appreciation for Alteryx.

I have a question

I have a CSV file with commas as Separators. In the file there are also monetary values with a comma as a decimal separator.

I would like to find the pattern (comma digit digit) and replace with (dot digit digit) to be able to use the text to columns based on comma, the digits could be any digits but should be replaced by the same two

"XYC,""2021.01.28"",""2021.01.28"",""faktura 1234"",""145915,06"","""",""NOK"",""2021.01.04"",""2021.01.28"","""","""","""","""",""""," 

"XYC,""2021.01.28"",""2021.01.28"",""faktura 1234"",""145915.06"","""",""NOK"",""2021.01.04"",""2021.01.28"","""","""","""","""",""""," 

Any help would be highly appreciated

Thanks

[danilang · Accepted solution]

Hi @Carl2 

You can use a formula tool with 

REGEX_Replace([Field1], ",(\d\d)", ".$1")

It will replace comma digit digit with period digit digit.  The $1 in the replace field will be replaced with the 2 digits from the input field

Dan

[Carl2]

Thanks!!