Expression make field blank if number of characters exceeds 2 : Omatic Support

How can we help you today?

Start a new topic

started a topic almost 2 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 10 months 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!

said almost 2 years ago

Hi Merrie Beth,

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

Click the Use Regular Expressions box.

Thanks,

John