Question
I would like to separate numerical data with a comma every 3 digits like "10,000".
Answer
-How to set
Please set the following parameter in Format Number logic.
###,###
"#" is not displayed if the input is zero, and "10000" is converted to the strings of "10,000".
-Notes
・About digits
If you input a number with more digits than the parameter set in Format Number logic, the number might not be formatted and the result might be "0".
Please set the logic parameter according to the largest digits to be input.
If the number to the left of a comma is zero, comma is not output. (eg. "10" remains "10" when formatted with "###,###")
It is recommended to set parameters with a larger number of digits than expected.
・About the data type after conversion
Please note that comma-separated data cannot be set in script variables of numeric type because it is strings.
-References
Format Number
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/DecimalFormat.htm
Comments
0 comments
Article is closed for comments.