GitHub user tlue added a comment to the discussion: How to trim numerical strings as per database column precision
I guess you need some.more examples or know more exactly what you want. I guess your DB is doing the usual European half up rounding. Ecxel by default often does a down or just cut off as often used in USA. A Calc step could maybe behave this way too. Have a look i.e. here as Hop is a java software. https://docs.oracle.com/javase/8/docs/api/java/math/RoundingMode.html Your two example numbers could be done with substring cutting off the last two letters an then let the DB auto convert it, not needing any further rounding any more to be done. GitHub link: https://github.com/apache/hop/discussions/6291#discussioncomment-15393726 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
