T
Tcs
I *think* I've seen what I want to ask, but I've tried it and can't get it to
work. So I figure that I'm remembering wrong or just have the wrong syntax. (My
*usual* problem.)
I have two separate fields of names, usually in the format of LAST, FIRST MI.
One column may or may not have commas. On column may or may not have the middle
initial. But both *usually* start with the last name.
If I want to grab the text UPTO the first space or comma, can't I do something
like:
LastName = left$([Column1]," ")
(I can't get it to work.) Or do I have to add code to check all the positions
starting at the beginning looking for my space or comma?
I appreciate the assist, thanks in advance,
Tom
work. So I figure that I'm remembering wrong or just have the wrong syntax. (My
*usual* problem.)
I have two separate fields of names, usually in the format of LAST, FIRST MI.
One column may or may not have commas. On column may or may not have the middle
initial. But both *usually* start with the last name.
If I want to grab the text UPTO the first space or comma, can't I do something
like:
LastName = left$([Column1]," ")
(I can't get it to work.) Or do I have to add code to check all the positions
starting at the beginning looking for my space or comma?
I appreciate the assist, thanks in advance,
Tom