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: 7232

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: 7232

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: 7232

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

Active Member


Joined: 07 Feb 2009
Posts: 984
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 Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm


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