I will have string data coming in, with 1, 2, or 3 digits preceding the decimal point, and 12 digits after the decimal point. An example would be 12.918171615141. I need to truncate everything past the 4th decimal digit, so that my example string would look like 12.9181.
Better yet would be if I could ROUND it properly, so that in this example I would end up with 12.9182. But to do so, I assume I would have to move the string to a numeric variable and use a math function. IF this is feasible, I need some sample code to handle this as well, i.e. how to properly get it into a numeric variable, then do the rounding, and get it back in to a string. TIA