Find a string in a dataset and eliminate those records

sameer · Posted: Fri Jan 25, 2008 2:50 pm

Hi,

I have a dataset from which I want to eliminate records having string "STRING". This string might be located in any position of a record.

Ex :

AAAASTRINGAAAAA
BBBBBBSTRINGBBB
STRINGCCCCCCCC

The output file should not have any records which has string "STRING"

I hope ICETOOL can do this. Any one have idea?

Regards,

acevedo · Active User Joined: 11 May 2005 Posts: 344 Location: Spain

search for SS (STRING SEARCH).

1,80,SS,NE,C'STRING'...

sameer · Posted: Fri Jan 25, 2008 3:00 pm

Thanks for immediate reply. Which Utility I need to for this command??

Regards,

Aaru · Posted: Fri Jan 25, 2008 3:00 pm

sameer,

Use the OMIT COND/SS substring search combination for your requirement. Search the DFSORT forum fro examples.

Aaru · Posted: Fri Jan 25, 2008 3:01 pm

sameer,

sameer · Posted: Fri Jan 25, 2008 3:02 pm

Thank you

sameer · Posted: Fri Jan 25, 2008 5:23 pm

Thanks Acevedo & Aaru it worked.

acevedo · Active User Joined: 11 May 2005 Posts: 344 Location: Spain

sameer · Posted: Fri Jan 25, 2008 7:15 pm

Yes Acevedo, I got this information from DFSORT forum.

Once again thanks for the information.

Ajay Baghel · Posted: Fri Jan 25, 2008 7:16 pm

The following sort card would eliminate all the records containing the sting 'STRING' anywhere in the 1 to 80 cloumn record :