Hello,
I have a text string that contains a social secuirty number and I want to extract it to a different column. Example:
Text string: D4AX3TY05T123456789T
I am trying to extract the SSN (underlined) and place it in a separate column. One thing about this text string is that the SSN starts at the 11th character and they all have a T at the end. Any help is appreciated.
fewaldron
I have a text string that contains a social secuirty number and I want to extract it to a different column. Example:
Text string: D4AX3TY05T123456789T
I am trying to extract the SSN (underlined) and place it in a separate column. One thing about this text string is that the SSN starts at the 11th character and they all have a T at the end. Any help is appreciated.
fewaldron