Change string with different formats to numbers

[BautistaC888]

Hello,
I need to change this strings with different formats to number type.

I attached an example.
Thank you.

[Qiu]

@BautistaC888 
I can see the different format meaning the dicimal point is either a period or a comma, so is the Thousand seperator.

So we can use a Regex to seperate them out then do some replace processing and joining them back.

[BautistaC888]

Thank you.
Could this work if i have multiple fields?

[Qiu]

@BautistaC888 
It will depend on how many columns.
if 2 or 3 then maybe it is better to apply this formula multiple times.

If more, then we can use the combination of Transpoe and Cross Tab then apply the formula.