Start a new topic

Expression make field blank if number of characters exceeds 2

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!


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! 

Login to post a comment