Try spec w1.2 1 substr fs - f2-* nw Regards, Richard Schuh
> -----Original Message----- > From: CMSTSO Pipelines Discussion List > [mailto:[email protected]] On Behalf Of Hughes, Jim > Sent: Monday, August 03, 2009 7:24 AM > To: [email protected] > Subject: Data Manipulation Question > > I have some data where there are spaces and words and dashes > in a string. > > Example: > > > > 24 6788 sda asdfasdf-rertwert-dfgff sdssd sdafsadfsd > > > > I'd like to retain the spacing in the record yet delete the > first bit of the word containing the > > Dash so the record would look like this: > > > > 24 6788 sda rertwert-dfgff sdssd sdafsadfsd > > > > > > I am sure someone will amaze me with the simplicity of the > solution I am not seeing. > > > > Best regards, > > > > > > ____________________ > > Jim Hughes > > 603-271-5586 > > "It is fun to do the impossible." > > >
