Start a new topic

RegEx to remove "N/a" addresses but not affect words containing "na"

We are using the Address Long Form dictionary offered in this forum post: 

https://www.omaticsoftware.com/Forums/tabid/108/aft/288/Default.aspx

 

We added a line to remove all values of "N/a," "NA," etc. by replacing with blank.


image


Now words containing ""na"" like ""National"" are affected:


image


 

Can someone explain how to escape these characters so they are not affected in a valid word but are still removed when they are the only value present in the address?  

 

Thank you

Sherry

Login or Signup to post a comment