Hi Merrie Beth,
Value to match on ^\S{3}.* Replacement value --BLANK--
Click the Use Regular Expressions box.
Thanks,
John
hi there, I'm trying to do something similar - I need to get only the first 20 characters of a string (like len(xx, 20) function... any ideas?
Thank you!
Merrie Beth Nauman
I am trying to create a dictionary to ignore any state value longer than 2 characters. We want the field to come in blank. Thank you!