community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Need Help with Regex for formatting the field contains numbers.

Highlighted
Asteroid

HI Good day.

 

I am trying to replace a character that is "." and "/" from filed as shown below example using Regex but after using it . its deleting any zero's and numbers in front of ".". May be i am using some thing wrong please help me out

 

Below is that example.

 

1.

Input: 884.400.954-49

Expected output: 88440095449

2.

Input: 20.288.137/0001-09

Expected Output: 20288137000109

 

Thanks in Advance

 

 

 

 

 

Alteryx Certified Partner

Hi,

 

maybe you posted twice ...

This formula should work:
REGEX_Replace([Field1], "[\.\-\/]", "")

 

I've attached a sample workflow.

 

Best regards

 

Roland

Labels