MVSFORUMS.com

ramy2016 · Beginner Joined: 18 Apr 2016 Posts: 46 Topics: 14

Good day everyone,
please let me know if this can be accomplished using DFSort.

Have records where a name field can have names mixed with some other trailing values, which could be numeric or alphanumeric.
There is at least one space between a name and other value, as well as possible trailing spaces.
There are no leading spaces.
The dataset is FB, LRECL=185, and the name field is at 37:25.

kolusu · Posted: Fri Dec 14, 2018 11:08 am Post subject:

ramy2016,

How would you handle names with embedded spaces?

ramy2016 · Beginner Joined: 18 Apr 2016 Posts: 46 Topics: 14

I was thinking of something like:
1. start validating from the end of a name field, going towards the beginning
2. check for strings ending with at least 2 or 3 numerics
3. go from there until the first space encountered

ramy2016 · Beginner Joined: 18 Apr 2016 Posts: 46 Topics: 14

So, yes - remove the last variable (if there) which would always end with few numerics.
This is what your example should look like.

kolusu · Posted: Fri Dec 14, 2018 3:52 pm Post subject:

ramy2016,

I think of couple of ways to get this done, but data like this would throw in a monkey wrench

ramy2016 · Beginner Joined: 18 Apr 2016 Posts: 46 Topics: 14

Sorry kolusu for a late response, didn't mean to be rude, just been busy at work and then holidays, vacations, etc.

I'm still wondering if this can be achieved in DFSORT, if I simplify Input.
Let's say a name field value would consist of either a Last name only, and a Last name and a one trailing value, like I presented in my first post.

kolusu · Posted: Thu Dec 27, 2018 12:18 pm Post subject: