If the data is the exact same and starts in a certain place, you can use one of the two options...
Sample Data: "xxxxxThis is a Test" If all rows started with "xxxxx" you could.. Update tablename set column = (SGET(columname,200*,6)) where (Sget(columnname,5,1)) = 'XXXXX' This would set the column to its value minus the first 5 characters. *200 can be adjusted to column width if desired. Sample Data : "This is xxxxx a Test" Update tablename set columnname = (SRPL(columname,'XXXXX','',0)) where columnname contains 'XXXXX' This would remove the xxxxx if the first characters are to be retained. Note that xxxxx string would be replaced everywhere though. -Bob ----- Original Message ----- From: Jim Belisle To: RBASE-L Mailing List Sent: Saturday, February 20, 2010 10:29 AM Subject: [RBASE-L] - deleting portion of text I want to delete a portion of a bunch of information at the beginning of 1200 rows of data. What function would I use to accomplish this? Jim
