Jim, What data type is the column?
Depending on your answer, String Manipulation functions like SRPL (with NULL as the "new value"), with SGET, SLOC, and other functions should get you on your way. Bill On Sat, Feb 20, 2010 at 11:45 AM, Jim Belisle <[email protected]> wrote: > Bill, > > > > The length of the portion I want to delete will vary but there will be many > rows with the same amount starting at the beginning of the field. > > I might have 50 that I need to get rid of 10 characters then another set > may have 100 where I need to get rid of 7. > > I will have a way to identify each group with another field in each row. > > I will be able to find each group with a WHERE clause. > > > > Jim > > > ------------------------------ > > *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Bill > Downall > *Sent:* Saturday, February 20, 2010 10:38 AM > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - Re: deleting portion of text > > > > Can you write a Where Clause that find the portion of the bunch? > > > > It it at the beginning of every row of the twelve hundred? Like the first > few characters of text of a certain column? > > > > Bill > > > > > > On Sat, Feb 20, 2010 at 11:29 AM, Jim Belisle <[email protected]> wrote: > > 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 > > > > >
