How can i convert this number 0214000000 to 02.14.00.00.00 in alteryx via formulas
an attached file of excel screenshot
Anyone has any ideas
Solved! Go to Solution.
Hi @StavrosAnd
Assuming your field is a string then you can use the following formula
TRIMRIGHT(
REGEX_Replace([Field1],'(\d{2})','\1.')
,'.')
Which will add a '.' after every 2 digits, and then remove the final '.'
Hope that helps,
Ollie
Thnx Solved