Handle numerics with comma as decimal indicator

Document created by pete_mccoy1.3055586893899446E12 Employee on Jan 23, 2015Last modified by dave_lesshafft on Mar 1, 2016
Version 2Show Document
  • View in full screen mode
Endpoint is providing an element value that is numeric, but the number mask is ##,##.  (Where the " , " is a decimal place qualifier.  You need to be able to convert that to a ##.## format. instead of having it treated as a number with no decimal value.
You can change the inbound element data type from number to character, then do a string replace function int he map that replaces  " , " with " . " (without the double quotes), and have the outbound element data type = number and provide the mask ##.##
1 person found this helpful