substring function
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
-
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.
Comments
1 comment