In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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