MVSFORUMS.com

sriramkarumuri · Beginner Joined: 07 Feb 2006 Posts: 28 Topics: 7

Hi,

i have file with huge records. eace record has the length of nearly 40000bytes.

lets say
123456ABCD........EFGH1....EFGH2....EFGH3....EFGH4....IJKL

i want to find the string EFGH in the above record as well length of n before IJKL.

output should be EFGH1....EFGH2....EFGH3....EFGH4....

Let me know, if you have solutions

Thanks in Advance

sriramkarumuri · Beginner Joined: 07 Feb 2006 Posts: 28 Topics: 7

its a variable length record

kolusu · Posted: Fri Jul 20, 2007 8:44 am Post subject:

dbzTHEdinosauer · Posted: Fri Jul 20, 2007 9:14 am Post subject:

sriramkarumuri,

this is an MVS mainframe? What programming languages (and their version) do you have available? also, do you have DFSORT?

and your requirement:

you want to extract data starting with EFGH1 and ending with the character before IJKL.
EFGH1 will always be in the record
IJKL will always be in the record and following EFGH1
neither EFGH1 nor IJKL appears more than once in a record

_________________
Dick Brenholtz
American living in Varel, Germany

sriramkarumuri · Beginner Joined: 07 Feb 2006 Posts: 28 Topics: 7

I want to extract data starting with EFGH1 and ending with the character before IJKL

dbzTHEdinosauer · Posted: Sat Jul 21, 2007 8:23 am Post subject:

That's one out of 6 questions answered.

Is this MVS mainframe
What languages (and their VSN,) do you have availabele.
Do you have DFSORT
2. EFGH1 will always be in the record
3. IJKL will always be in the record and following EFGH1
4. neither EFGH1 nor IJKL appears more than once in a record
_________________
Dick Brenholtz
American living in Varel, Germany

expat · Posted: Sat Jul 21, 2007 8:26 am Post subject:

This should be quite interesting, as Kolusu as quite correctly pointed out that the record length exceeds 32,760.
_________________
If it's true that we are here to help others,
then what exactly are the others here for ?

dbzTHEdinosauer · Posted: Sat Jul 21, 2007 9:20 am Post subject:

sriramkarumuri · Beginner Joined: 07 Feb 2006 Posts: 28 Topics: 7

Hi Dick,

Can you give me more picture on this

How to get the start position or offset? Is there any string functions available for this?

dbzTHEdinosauer · Posted: Fri Jul 27, 2007 12:45 am Post subject:

sriramkarumuri,

Answer these 6 questions:

Is this MVS mainframe?
What languages (and their VSN,) do you have available?
Do you have DFSORT?
will EFGH1 always be in the record?
will IJKL always be in the record and following EFGH1?
will either EFGH1 or IJKL appear more than once in a record?

very hard to answer your question without knowing the answer to 2.
I will not provide/suggest a solution until I have 6 satisfactory answers from you.
Then, there will be many members of this forum in addition to me who can provide you a solution(s).

bis dann!
_________________
Dick Brenholtz
American living in Varel, Germany