Albert, That worked perfectly and quickly.
Thank You, David Fowler -----Original Message----- From: [email protected] [mailto:[email protected]]on Behalf Of Albert Berry Sent: Monday, 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. > ================================================ > > > >
