Update tablename Set colname = (SSUB(colname,1)) Dennis McGrath
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of David Fowler Sent: Monday, July 26, 2010 9:46 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Removing characters following a comma 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. ================================================
