I have these two tables, that i want to join. But as you see one of them has two 00 in beginning.
How can i delete from the first table the first two zeros or ad them to the other table. But i would prefer to delete them.
Solved! Go to Solution.
Hey @NicoLehmann, as the field will be stored as a string you can use the TrimLeft() function to remove the '0' characters from the start:
If the other field - in the second table - is numeric then you'll need to add a Select tool and make them uniform (i.e. both numeric or both strings) in order to be able to conduct a join.
Hello, @NicoLehmann.
I would use a Regular Expression inside a Formula tool. I would use the REGEX_Replace function to match a pattern that has any number of leading zeroes, but only return the digits after the leading zeroes.
Please see the screenshot and the attached workflow.
Thank you for the formula, but what does "$1" exactly mean? You are replacing any number of leading zeros with what?