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

Alteryx designer Discussions

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

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,

 

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

 

I've attached a sample workflow.

 

Best regards

 

Roland

 

 

Labels