IBM Mainframe Forum

Hello,
I am stuck on what may be a simple algorithm, that has yet to pop into my head. Essentially, I am parsing this report, by line, using a stem variable and looking for the line that contains the word 'AMOUNT.' My problem is, after I find that line, I need to return values from the NEXT line.

Here is a snippet of the report:


Here is the REXX code I am currently using to find the line containing 'AMOUNT':


Any suggestions are much appreciated!

since You did not tell enough ( on what happens after ) we are just guessing


to get

Thank you for the reply Enrico,

I think I understand what you are saying; this would work (and i've already coded something similar to this) if the number of lines in the report never changed and I could always count on the values I need being on the same line. If that was the case, I could probably just go right to that line and avoid searching for 'AMOUNT.'

Unfortunately, I have to account for the unknown. All I am confident of is that the values I need to pull are going to be on the line after the "ITEMS AMOUNT ITEMS AMOUNT" line.

So, i'm struggling with a way to return the next line after I find the line containing 'AMOUNT.'

Ah jeez, I didn't scroll through all of your code first...
That worked beautifully!
Thank you!

Actually, adding a simple 'i = i +1' worked.
I overlooked the obvious.

I'm hoping you can help me add 1 more layer to this.

I now need to get a value from the next line, which I can do using the method described above. However, I also need a value from the line after that (i +2).

For example, if the report is this:


I need to return both '100' and '450'

I can do one or the other, by commenting out one of the two 'i + ' statements in this code:



Can someone help me to figure out how to return both the next line, and the line after that?

I appreciate everyone's help and patience!

IMNSHO You have more problems with basic logic than with the language itself.

after the first increment of I what is the line pointed to

use Your neuron to find out what increment to apply to i in order to point to the i(TOTAL) + 2 line

You are apparently a very competent programmer, I can respect that. You have well over 2,000 posts, which leads me to believe you are a well-respected member of this message board. I would also wager that you have helped many people who are struggling, like myself, get results quicker. Kudos!

Drivel removed

a quote from the previous drivel that was removed

That was uncalled for.

You are correct, Enrico has helped numerous people and is well respected by all. It is not clear why you continue to be dis-respectful.