Change 0.45 to .45???

[rogersm01]

Hi

I have a set of data with an instance of 0.45. This is the area of a unit and needs to be multiplied by how many units there are. The current process is onerous but the output drops the zero for any instances of 0.45 or 0.90. See below examples of concatenated entries with .45 and .9 at the end:

2023;3;101846;119;1;12;.45

2023;3;101846;119;4;12;.9

I can mirror this exactly using Alteryx apart from my output reads 0.45 and 0.9 for these entries:

2023;3;101846;119;1;12;0.45

2023;3;101846;119;4;12;0.9

is there a way to drop the 0? 

thanks.

[Matthew · Accepted solution]

how about a regex replace? 

REGEX_Replace([yourString], ";0\.(\d+)$", ";.\1")

 

[rogersm01]

That's great - thanks a lot