Watch out for "Van Der Wald, Frank" and "St. Clair, Yves" and the like!
Regards, Stephen Markson 416 512 6950 > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Albert > Berry > Sent: July 26, 2010 11:56 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Removing characters following a comma > > use SSUB(lastname) to replace the first element. > > SET LastName = (SSUB(LastName,1)) WHERE LastName LIKE '%,%' > > Albert > > David Fowler wrote: > > Using the lates build of 7.6. > > > > Is there a way to strip text following a comma in a text column? I've > got > > 130,000 plus rows of data. Some have been entered as lastname, > firstname > > while others are not. I'd like to get rid of the ,firstname in any > column > > that has it. > > > > Thanks in advance for any help. > > > > David Fowler > > > > --- RBASE-L > > ================================================ > > TO POST A MESSAGE TO ALL MEMBERS: > > Send a plain text email to [email protected] > > > > (Don't use any of these words as your Subject: > > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [email protected] > > In the message SUBJECT, put just one word: INTRO > > ================================================ > > TO UNSUBSCRIBE: > > Send a plain text email to [email protected] > > In the message SUBJECT, put just one word: UNSUBSCRIBE > > ================================================ > > TO SEARCH ARCHIVES: > > Send a plain text email to [email protected] > > In the message SUBJECT, put just one word: SEARCH-n > > (where n is the number of days). In the message body, > > place any > > text to search for. > > ================================================ > > > > > > > > > > > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 9.0.851 / Virus Database: 271.1.1/3020 - Release Date: 07/26/10 > 02:36:00
