For the given text:
The following works well. thank you
Sometimes there is a space at the end of the first name and/or last name and the action then fails.
I looked up filtering white space and used = [ \t]+$ to no avail.
Appreciate any help
if we could maybe be prepared for a space at the end of the last name and/or at the end of the first name, so that it works whether the space is there or not. - possible? - Thanx
What I usually do with this sort of problem is run a “sanity” script to prepare input text for find and/or find/replace operations.
So for instance I'll:
Strip leading & trailing vertical whitespace ⇢ \A\s+|\s+\Z
Strip leading horizontal whitespace ⇢ ^\h+
Strip trailing horizontal whitespace ⇢ \h+$
Fix comma spacing ⇢ \h*,\h* to “, ”
Every time I encounter an anomaly in my input text I'll add another fix to the sanity filter.
This method keeps me from having to go crazy trying to predict every eventuality in my input text.
I tried the following to no avail. It did not remove any spaces.
In addition, if that worked it would not take care of the internal space after the last name,
Campbell , Colleen
it only addresses 'line ending' white spaces. Correct?
This worked for removing the space before the comma, which is the immediate issue. I hear what you are saying though, to not fix just one issue but be able to resolve a number of issues as they appear.
As always, grateful for your help.
Expand Bohrer, Phyllis
Search for a Regular Expression lie this:
The ? mean that the (\s) maybe is there or not...
Check it out here...
that does not work for me to set the variables First name and last name on the text:
Nor does it work on regex101.com
Boland , Lauren
Capture first name and last name, just keep in ( ) what you need to capture
\s* is generally better than
\s? for this kind of thing.
* means zero or more,
? means 0 or 1.
\s includes line endings, so you need to be slightly careful when using it.
\h matches only horizontal white space, but is not supported until 10.11+, so if you happen to be using 10.10 or earlier, that will not work.
Here is my solution:
I prefer using
\h* which will match 0 or more horizontal white spaces.
this pattern will match names that contain "-" and
"'", as in:
\R to match any new line character, not just LF
Note that \h and \R require OS X 10.11+
I just updated my post to correct a very minor error (which doesn't impact the match). I had an extra single quote (
') not needed.