I have seen this solution before as well. There were a bunch of examples in the sort tips related to XML parsing. Basically uses the @ as the delimiter and create a fixed area before the @ and after the @ which should allow it to be sorted.
Rob Schramm On Sat, Jul 15, 2017, 3:34 PM Scott Barry <[email protected]> wrote: > On Sat, 15 Jul 2017 14:18:41 -0500, Edward Gould <[email protected]> > wrote: > > >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 > > I recall prior threads on parsing IP-address strings, which would be > similar in context - recommend searching the archives for such reference. > > Scott Barry > SBBWorks, Inc. > http://sbbworks.com/ > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > -- Rob Schramm ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
