0

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#

1 comment

Please sign in to leave a comment.