I need to write pattern matching to escape a whitespace character followed by *FLC. This is for our vendor names, and some of them look like this:
ABC Contracting, Inc. *FLC
I need to change this so that it reads
ABC Contracting, Inc.
with no whitespace character following Inc.
The *FLC is ALWAYS at the end of the vendor name (in the situations where it applies).
I need to remove these characters when addressing the contractor, since this really isn't part of their name, just part of our configuration process to note which vendors are FLC's (farm labor contractors).
I'm sure this is possible through pattern matching and regular expressions; however, I just can't figure it out. Any help you can give would be greatly appreciated!