Rounding with more than one decimal

[GCEagles]

Here is an excerpt of the data that I need to be transformed:

Current	What I need
22.10399999999999	22.1040
22.1092.11	22.1092.11
22.1040.10	22.1040.10
22.2014999999998	22.2015
FH10202020	FH10202020
022100210FSB	022100210FSB

I need to round the first set of decimals to 4 places. The data is currently in string format because I will lose the data with the letters, if I convert to double

[CharlieS]

I achieved the desired result by splitting to rows on the period, then rounding the values that contained three 9's to the first 4 characters, then recombine the values by concatenating with a ".". 

Check out the attached workflow and let me know if that works for you.

[GCEagles]

Hey, sorry I also realized that in some instance there's data that is:

Current	What I need
22.20230000000000000001	22.2023

Where now that would be rounded down, so I would just add "000" to the formula?

[CharlieS · Accepted solution]

No problem. I added and OR condition that looks for "0000" in addition to "9999" (i also extended to 4 characters).

[GCEagles]

Perfect thank you so much!