Hello,
I have a series of ssns that have a space & 1 or 2 numbers at the end, such as 123456789 1. I am trying to removed everything after the space. I have tried several trim expressions but nothing works, either the space & number(s) are still there or it returns a zero. I'm thinking that possibly a RegEx expression will work but I'm not sure how to write it? Any help/suggestions would be much appreciated.
Thanks so much,
Solved! Go to Solution.
Hi @kvoelker
A Text to Columns tool using \s delimiter is very simple. It splits the expression in two columns, then you can get rid of the second one.
Cheers,
Hi @kvoelker,
Use the Text To Columns tool from the Parse category.
Set '\s' (i.e. a space) as the delimeter and the number of columns to 2. Then you can remove the second column and you are left with the data you want.
Hope this helps.
Luke
Hi All,
The text to column solution that @Thableaus provided worked well. Thank you all so much for the help! You are the best!
Thanks again,