Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Removing only two numbers AFTER a decimal

mfranchino21
7 - Meteor

Hi, i have a string that will look something like this; 

 

45729816345272.36 73648728627811.854376628188193.4792986181921763484553.34 375376327236328textexttext 4572899473689494.233254756466

 

Every time there is a decimal,  I want to remove the following TWO numbers. so, if it sees a decimal, it will take away the following 2 numbers. 

 

I would want the above input to look like this; 

 

45729816345272. 73648728627811.4376628188193.92986181921763484553. 375376327236328textexttext 4572899473689494.3254756466

4 REPLIES 4
binuacs
21 - Polaris

@mfranchino21 try the below regex 

image.png

CoG
14 - Magnetar

Very odd use case, but here you go!

2023-11-15_15-14_Double Digits.png

Edit: Didn't think about RegEx, but that's way cooler! Nicely done, @binuacs 

mfranchino21
7 - Meteor

awesome, thank you!

TimN
13 - Pulsar

REGEX_Replace([string],'(\.\d{2})', '\.')

Labels
Top Solution Authors