Change data structure

[beatrizmguerreiro]

Hello, 

I have a set of data that represent the same information, but have different data structures. 

Rate

16,00', '%'

'16.00', '%'

0.00'

16.00%

'16.000', '%'

How can I convert this column into the following structure?

0,16

0,16

0

null

0,16

0,16

Thank you very much, in advance

[Emil_Kos · Accepted solution]

Hi @beatrizmguerreiro,

In order to achieve this you need to use regex. As I am not a master of it I am using a specific tool called regex and I am using below expresion:

\d+.\d+

I am searching for a string that contains one or more digits dot represent any character and once more I am looking for one or more digits.

This is my workflow:

This is the final output:

Please mark my post as a solution if this was helpful!

[Qiu]

@beatrizmguerreiro 
@Emil_Kos gives excellent idea for this one.

Just  I noticed that you are using comma rather than period for numbers. so made a bit modificaiton.