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.



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 or Signup to post a comment