Say I have 105.6546 and 5646.546356, how can I drop only the decimal and values to the right of the decimal? So my final values will be 105 and 5646.
Solved
Remove decimal and decimal values without rounding.
+4- Contributor
Best answer by jdh
Using the arithmetic editor in any of the transformers that create attributes, you can use @int() or @floor().
@int will truncate the value, @floor will return the next lowest integer, these are identical for positive values, but will differ by 1 for negative values.
@int(10.1) =>10
@floor(10.1) =>10
@int(-10.1) => -10
@floor(-10.1) => -11
+18- Contributor
The ExpressionEvaluator transformer can be used, using the floor function. It will be in the Math section.
+4- Contributor
erik_jan wrote:
The ExpressionEvaluator transformer can be used, using the floor function. It will be in the Math section.
+28- Contributor
- Best Answer
Using the arithmetic editor in any of the transformers that create attributes, you can use @int() or @floor().
@int will truncate the value, @floor will return the next lowest integer, these are identical for positive values, but will differ by 1 for negative values.
@int(10.1) =>10
@floor(10.1) =>10
@int(-10.1) => -10
@floor(-10.1) => -11
+18- Contributor
erik_jan wrote:
The ExpressionEvaluator transformer can be used, using the floor function. It will be in the Math section.
For what it's worth, if the @floor function satisfies your requirement, the AttributeRounder (Decimal Places: 0, Round-off Direction: Down) can also be used. Instead of the @int function, the StringReplacer with this setting works for you.
- Mode: Regular Expression Replace
- Text to Replace: (.+)\\..*
- Replacement Text: \\1
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.