Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Question related to add character in a sting

StavrosAnd
5 - Atom

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

2 REPLIES 2
OllieClarke
13 - Pulsar
13 - Pulsar

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

OllieClarke_0-1612371649731.png

 

StavrosAnd
5 - Atom

Thnx Solved

Labels