Does this need to be a mainframe solution? How many records are involved?
If not a lot of data, I load this type of data to Excel. The using the DATA tab, I then highlight the column and use the TEXT TO COLUMS function to break on the @ Do my sorts, then put it back together (using CONCAT function), or leave in excel for further filtering. Lizette > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf Of Edward Gould > Sent: Saturday, July 15, 2017 12:19 PM > To: [email protected] > Subject: Sort Question > > One of my users asked me this question and I am not quite clear on how to > respond. > Given an email address [email protected] <mailto:[email protected]> (example) > > He just wants to sort on the field before the @ and then for a secondary sort > the bbb field. Both fields are variable in length (not sure what the max is). > Any suggestions on how to do this? I have tried RTFM but maybe I am not > looking at the question correctly . > > Ed ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
