How do I correctly convert recurring decimals properly?

Question

I have a column with string and numerical values which includes decimals too.

I want to maintain the integrity of these columns while converting the recurring decimal numbers to proper numbers like:

1068.06999999999
999.000999999999
999.001999999999
999.005999999999

Should be

1068.07
999.001
999.002
999.006

I am trying regex identify and convert however I am not getting the right output

I dont know how to correctly do the same

Please find example workflow attached.

Example.yxmd

HW1 · Answer

This solution is forcing the decimal values to whatever the user defines. While I am looking for a solution that works when there are recurring decimals and that needs to be restricted.

Thanks

HW1 · Answer

Hi @flying008  Can you please help me with an example workflow of the solution? I think this works best as I have provided a simple sample of more varying examples. This can be most helpful.

Thanks

flying008 · Answer

Hi, @HW1

maybe you need the dynamic solution.

Input　Output1009.00699999999　1009.0071068.02199999999　1068.0221068.02399999999　1068.0241068.04099999999　1068.0411068.06999999999　1068.07999.000999999999　999.001999.001999999999　999.002999.005999999999　999.0060　00E003　0E0030E004　0E0040E006　0E0060E007　0E0070E009　0E0090E00B　0E00B0E00D　0E00D0E00E　0E00E0E00F　0E00F0E00H　0E00H1455.02　1455.021455.021　1455.0211455.022　1455.0221455.023　1455.0231455.025　1455.0251455.026　1455.0261455.027　1455.0271455.028　1455.0281455.029　1455.029