Question related to add character in a sting

[StavrosAnd]

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

[OllieClarke · Accepted 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

[StavrosAnd · Accepted solution]

Thnx Solved