• Font Size
  • S
  • M
  • L

Search via FAQ No.


  • No : 30842
  • Open Date : 2019/09/05 17:15
  • Print
NEW

[DataSpider Servista] I want to output a specific numerical value with the specified number of digits of 0 added before the value.

When mapping, I want to output a specific numerical value with the specified number of digits of 0 added before the value. Please tell me how to do it.
 
I want to change "123" to "0000000123".
 
Category : 

Answer

If you want to output a specific numeric value as a formatted string, you can use the [Number Formatting] logic to output in the specified format.
 
You can store the input data "123" as “0000000123" to a character string type of script variable by specifying "0000000000" in [Format] of the [Number Formatting] logic.
 
file_image
 
 
Please refer to the following help for details about the Numeric Formatting logic.
  • [Mapper Logic Guide]-[String]-[Number Formatting]
 
Version Information
Ver.4.1、Ver.4.0