Forum Discussion

Helper II

6 years ago

Solved

String to Number - Multiple Conditions

Hey guys, I want to model a data which is string and turn it to number, however there are some details who might be hard to treat. The data comes from a chain of strings, like adresses, zip codes, n...

Need Help

ImkeF
6 years ago
Hi renanc ,

your data was a bit dirtier than expected and I realized it a bit late. So the code might not be ideal, but it seems to work (see attachment at the end of this message).

Didn't clean it up, as I had to spend more time than expected already...

String to Number (1).pbix116 KB

renanc

Helper II

6 years ago

ImkeF
Link to a file:
https://drive.google.com/file/d/15y2J3Ke4nHyLal9fcGibqjZZvPIUZeBS/view?usp=sharing

Necessary Step

You can work on in the step marked as red, the others one were just a play with some trials like removing text, however when im forcing into text removal, the cents are being dropped as units in the steps ahead, for example: 10.000,53 or 10,000.53 = 1000053.

Thank you for your help :)

ImkeF

Community Champion

6 years ago

Hi renanc ,

your data was a bit dirtier than expected and I realized it a bit late. So the code might not be ideal, but it seems to work (see attachment at the end of this message).

Didn't clean it up, as I had to spend more time than expected already...

String to Number (1).pbix116 KB

renanc
Helper II
6 years ago
ImkeF

You totally solved my issue, I didn't have a clue to this solution and you did it!!

u don't know how much this is going to help me out now =D

Thank you very much for your time and effort!!

Forum Discussion

String to Number - Multiple Conditions

Related content

Multiple conditions Index

Multiple Donut charts with conditions

Conditional Column with Multiple Conditions

IF - Multiple conditions

Conditional Column with Multiple Conditions