Extract records from file.

passion_sujesh · Posted: Fri Mar 20, 2009 8:32 am

Hi i have an requirement in which i have to extract all the records from a file which have value 'fetch' in them. This value can be in any position in the record.The value 'fetch' will always be after 'Include' . Is it possible to do this in sort or any other utility.

Example:
Input file:
123456 Include fetch-1 87456
5487 Include fetch-2 54781
1245 789658 74122

Output:
123456 Include fetch-1 87456
5487 Include fetch-2 54781

Last record should be omitted as it does not have value fetch in it.

Thanks in advance.

dick scherrer · Posted: Fri Mar 20, 2009 8:40 am

Hello,

You mention "include" . . . Does this have anything to do with the requirement? If a record had "fetch" but not "include" should it be selected or skipped?

Which sort product is used on your system?

passion_sujesh · Posted: Fri Mar 20, 2009 9:24 am

If the record has no include then it can be skipped. I am Using DFSORT.
Can you please help me in this.

gcicchet · Posted: Fri Mar 20, 2009 9:33 am

Hi,

try this

dick scherrer · Posted: Fri Mar 20, 2009 9:38 am

Hello,

You might try something like:

passion_sujesh · Posted: Fri Mar 20, 2009 9:54 am

Thanks dick, it is working fine.

dick scherrer · Posted: Fri Mar 20, 2009 10:05 am

You're welcome - thank you for letting us know

Gerry, i see you're still quicker on the keyboard

d

gcicchet · Posted: Fri Mar 20, 2009 10:22 am

That's what happens when one stops monkeying around

Gerry

dick scherrer · Posted: Fri Mar 20, 2009 10:44 am

Or starts. . .

d