Remove leading zeros with spaces using SORT

Thirumurgann · New User Joined: 13 Feb 2008 Posts: 36 Location: India

Hi Guys,

Please suggest some ideas on replacing leading zeros with spaces.
I m processing VB file.

My input is like:

Frank Yaeger · Posted: Tue Sep 20, 2011 10:43 pm

Thiru,

I edited your post with code tags to show what I believe your input and output actually look like. If that's the way they look, then you can do what you want with these DFSORT control statements:

Thirumurgann · New User Joined: 13 Feb 2008 Posts: 36 Location: India

Hi Frank,

Thank You so much. This is the simple solution that every one could understand. Thanks for offering such simple.

Many of our forum people reply are bit difficult to understand.

Frank,
One clarification again

I used tha above sort card and i got o/p like:

My output :

+16080| +24744|MD|FAR |N|10~Home
+142020| +142020|CA|FM |N|10~Home

But i dont want + symbol before that. Any sugesstions welcome.

Thanks,
Thiru

Bill Woodger · Posted: Wed Sep 21, 2011 2:12 pm

Thiru,

If you can work out that it is the TO=FS which is causing your data to look like that, try then searching in the manual for "field formats" and seeing if you can pick one which you think is better, then try it out.

Frank Yaeger · Posted: Wed Sep 21, 2011 10:14 pm

Thiru,

My DFSORT job produces the output you requested. You would NOT get the + signs with DFSORT (ICE messages), so I assume you're using Syncsort (WER messages), not DFSORT.

I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.

Note: If you think you are using DFSORT, show me the complete JES listing for your run.