0

substring function

David Paras

April 24, 2013 19:48

None

Follow

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#

• Facebook
• Twitter
• LinkedIn

1 comment

• 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) )"