IBM Mainframe Forum

Hello. I need help with something and maybe someone can help me out. I'll try and explain. I have a field called first_name that contain the person first name in that field. The field is 15 character in length.

Example:

first_name: John D

I am doing a data extraction that I only want JOHN and not the D. How would I go about doing that?

Another question as well. I have a field that is an address field. In that field, if the first letter is an "N", I would like to perform a statement to clear the address field to spaces. The address field is 20 character in length.

Any help is much appreciated. Thank you

Reference modification will do both of these.

Find the first space in the first name field and store the location of that space in WS-I.


For the second one:

Hello,

What if the first name is "JIM BOB "?

Hello, Jim?



What Dick's example points out is that the rules are not comprehensive yet -- your cutting off at the first space won't always get good results (J K Rowling, for another example).

Thanks Robert for responding. The address code worked great.

Can you explain to me the First Name issue. I'm not quite understanding.

I define WS-I first with

10 WS-I PIC X VALUE SPACE.

THEN IN THE PROGRAM, I PUT THIS STATEMENT:

MOVE FIRST-NAME (1:WS-I) TO OUTPUT-VAR.

The output-var is the data containing "JOHN"

Thanks again for your help. It is much appreciated.

You guys make a very valid point. As for now, I would like to get it to work so it only contain "JOHN" instead of "JOHN D"

Then when the issue arrise with the two name JIM BOB or J R Rowling, I would deal with it at that time. Thanks again.

Thanks Robert. Thats a quick response. It worked for the first record however it didn't continue down to the rest of the data.

Did you reset WS-I to zero before the second record?

i got it to work Robert with your suggestion with zero it out before the 2nd record. Its working as it should. Thank you very much for your help in this.