Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

sort to correct a VB file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
pema_yozer

New User


Joined: 16 Feb 2009
Posts: 45
Location: pune

PostPosted: Tue Aug 23, 2011 3:30 pm    Post subject: sort to correct a VB file
Reply with quote

Hi All,
I have an issue with a VB file which i'm producing.
Due to the nature of the utility the data gets padded with trailing spaces
i can remove the spaces but this lead to getting two junk character in from of every record
so we have two solution
Code:
input
5934567
FFFFFFF44444
59345670000
2
F4444444444
20000000000

output
5934567
FFFFFFF4
5934567
2
F
2


remove the trailing spaces
or
2) remove the starting two junk
Code:
input
.*abcd
.^efghik

output
abcd
efghik

caould you please let me know if dfsort coud do this
the file is a VB file with rec lenght of 800
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Tue Aug 23, 2011 3:36 pm    Post subject: Reply to: sort to correct a VB file
Reply with quote

Whoop! Whoop! Whoop! Junk Alert! Junk Alert! Captain Kirt to the Bridge please. Captain Kirk to the Bridge.

Now, where's that post...
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Tue Aug 23, 2011 3:38 pm    Post subject:
Reply with quote

Pema,

Let me guess, this is associated with the file from your earlier posts today? You've (already) given up with getting that to work and you want to mess about with the output dataset.

You've done that, and you don't like the result, so you want to do some more messing?
Back to top
View user's profile Send private message
pema_yozer

New User


Joined: 16 Feb 2009
Posts: 45
Location: pune

PostPosted: Tue Aug 23, 2011 3:43 pm    Post subject:
Reply with quote

Hi Bill,
i checked my files and found that the file is VB but there are trailing spaces,
when i'm transfering it to my desktop the trailing spaces are automatically removed and when i uplaod it and zip it every thing seems fine.

how ever when i directy zip it i get a problem which is the spaces which are present originally.so the issue is not with the zip but with the file itself
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Tue Aug 23, 2011 3:47 pm    Post subject: Reply to: sort to correct a VB file
Reply with quote

Hi Pema,

So, shall we go back to the original topic and try to work out how to get a correct solution at source, rather than continually knocking little bits of data off here and there?

Then this topic here can be locked and "kicked-into-touch" by one of our kind moderators.
Back to top
View user's profile Send private message
pema_yozer

New User


Joined: 16 Feb 2009
Posts: 45
Location: pune

PostPosted: Tue Aug 23, 2011 3:50 pm    Post subject:
Reply with quote

sure..
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1018
Location: Oostende, Belgium

PostPosted: Tue Aug 23, 2011 4:01 pm    Post subject:
Reply with quote

SIASD!

The two characters you might see are quite likely the RDW, translated to ASCII.

Why do we actually bother when the TS's have absolutely no clue...
Back to top
View user's profile Send private message
pema_yozer

New User


Joined: 16 Feb 2009
Posts: 45
Location: pune

PostPosted: Tue Aug 23, 2011 4:05 pm    Post subject:
Reply with quote

yep prino it is the rdw translated to ascii
but i need to get rid of it
Back to top
View user's profile Send private message
pema_yozer

New User


Joined: 16 Feb 2009
Posts: 45
Location: pune

PostPosted: Tue Aug 23, 2011 4:10 pm    Post subject:
Reply with quote

USed VLtrim and that solves the problem.. thank you guys for your time
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to change 'K' or 'M' use Sort vice_versa DFSORT/ICETOOL 5 Thu May 18, 2017 7:11 am
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us