How can we help you today?
Expression make field blank if number of characters exceeds 2
2 CommentsSorted by Oldest First
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!
Help Desk Software
by Freshdesk
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!