Alteryx Designer Desktop Discussions

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

Appending digits after decimal

saivig68
7 - Meteor

I have a following digits and would like to use a regex to convert to the following , can some one point me in the right direction.

 

 

Current StateDesired State
12.0212.02999
1.5641.56499
0.30.3999
0.58960.58969
0.999990.99999
1 REPLY 1
RodL
Alteryx Alumni (Retired)

Attached is an example that uses both RegEx and a Formula tool expression to pad out 9's in the decimal.

 

I believe this works even with whole numbers (no decimal).

Labels