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
Solved! Go to Solution.
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!
@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.