substring function

David Paras

• April 24, 2013 19:48

Our ssn is stored xxxxxxxxx
I need to map to output as xxx-xx-xxxx.
Plan substring input ssn# 1,3 cat '-'substring input ssn# 4,2 cat '-' substring input ssn# 6,4 --------------------------> output ssn#

0

• 

  David Paras

  • April 24, 2013 19:49

  you have to apply the below textual rule on the target node of Data Mapping:

  "concat( substring( $Input_Source_Schema/Root/Record/Record1, 1 , 3) ,'-', substring( $Input_Source_Schema/Root/Record/Record1, 4, 2) ,'-', substring( $Input_Source_Schema/Root/Record/Record1 , 6 , 4) )"

   

  

  0

Please sign in to leave a comment.