Page 1 of 1

Search string using ICETOOL or DFSORT

PostPosted: Wed Nov 11, 2009 4:04 pm
by radhika_engimuri
Hi

I have a requirement to separate records from input file based on a string (Not constant)

I have two input files - one file having record with a string and another input file with multiple records

Input file 1

0001AAAAAAA --- This AAAAAAA can be any string (it is not a constant). Now I want to search in File2 with this string to find records that match the string and want to separate out matched records into another file

Ex: If AAAAAAA = 8765432 ---- this is an example, I dont have any clue what value varialbe AAAAAAA holds exactly

Input file 2

00016543217
00026543217
00036543217
00048765432
00058765432
00068765432

My output should look like

00048765432
00058765432
00068765432


Thanks in advance,
Radhika

Re: Search string using ICETOOL or DFSORT

PostPosted: Wed Nov 11, 2009 11:19 pm
by Frank Yaeger
What is the RECFM and LRECL of your input file?

What is the starting position and length of the string in input file1? Does it start in position 5 after the 0001, or is the 0001 really not in the record, so the string starts at position 1?

Is the 0001, 0002, etc really in input file2?