Here is an excerpt of the data that I need to be transformed: CurrentWhat I need22.1039999999999922.104022.1092.1122.1092.1122.1040.1022.1040.1022.201499999999822.2015FH10202020FH10202020022100210FSB022100210FSB 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

Rounding with more than one decimal

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

Input

Accepted answers

CharlieS

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

20200121-RoundComponent2.yxmd

All comments

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.

20200121-RoundComponent.yxmd

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

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

20200121-RoundComponent2.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703