No problem (well, ok, it took a little Googling...). Put a single space in your Replacement value, add this two-character value in your Values to match on: /n
W
Wayne Pozzar
said
over 7 years ago
Make sure that you have Use Regular Expressions checked!
S
Stephanie Grubb
said
over 7 years ago
Hi. Can anyone here direct me to a pre-populated index/dictionary of regular expressions that I can use to better match imported records (e.g. apartment = apt = APT.; street = ST. = St.) I was told that such a list already exists on the OMatic forums...?
A
Amanda Allen
said
over 7 years ago
Hi Stephanie,
This post includes the regular expression you need to format addresses.
Thank you, Amanda Omatic Support
S
Stephanie Grubb
said
over 7 years ago
Thank you, Amanda! I just added the list and will try it out now.
William Johnson
Can anyone help me with a Regular expression that would allow for a partial string match?
I need to remove /n from certain imports and replace it with a space.
Thanks,
Billy