View previous topic :: View next topic
|
Author |
Message |
pema_yozer
New User
Joined: 16 Feb 2009 Posts: 54 Location: pune
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
pema_yozer
New User
Joined: 16 Feb 2009 Posts: 54 Location: pune
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
pema_yozer
New User
Joined: 16 Feb 2009 Posts: 54 Location: pune
|
|
|
|
sure.. |
|
Back to top |
|
|
prino
Senior Member
Joined: 07 Feb 2009 Posts: 1306 Location: Vilnius, Lithuania
|
|
|
|
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 |
|
|
pema_yozer
New User
Joined: 16 Feb 2009 Posts: 54 Location: pune
|
|
|
|
yep prino it is the rdw translated to ascii
but i need to get rid of it |
|
Back to top |
|
|
pema_yozer
New User
Joined: 16 Feb 2009 Posts: 54 Location: pune
|
|
|
|
USed VLtrim and that solves the problem.. thank you guys for your time |
|
Back to top |
|
|
|