Expression make field blank if number of characters exceeds 2 :

How can we help you today?

Start a new topic

started a topic over 3 years ago

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!

2 Comments

said over 3 years ago

Hi Merrie Beth,

Value to match on ^\S{3}.* Replacement value --BLANK--

Click the Use Regular Expressions box.

Thanks,

John

said over 2 years ago

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!