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
20 - Arcturus

@mfranchino21 try the below regex 

image.png

AndrewDMerrill
13 - Pulsar

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