I have been looking for resolution to capture all text, separated by several spaces (so there are fields separated with just a single space, which need to remain as two words) before and after every field. I’m using RegEx Builder.
The Whitespace option in RegEx Builder makes all the text one long line, and another post showed this suggestion “[a-z]+\s?[a-z]+”, but it also didnt help.
The text typically looks like this:
" NOT LOGGED IN General Retailer "
I have used the Replace activity, as I wanted to replace all unused spaces, should I be using Matches rather?