Remove Alphanumeric from file

[maxcrook]

I have a file on one of our production servers that was created by the DSPAUTUSR command and output to a file.

I now want to strip out the Alphanumeric ids to remain with only the fully alpha profiles ie. WILLIAM


Once this is done I then have to query ids with:

Numerics at the end of the profile ie BILL1

Any ideas ????

 

[maxcrook]

Should have stated im on an iSeries 570 running vr54.