IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to remove spaces in a file using sync sort


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
viji_rags

New User


Joined: 04 Jun 2010
Posts: 24
Location: chennai

PostPosted: Fri Oct 18, 2013 7:02 pm
Reply with quote

Hi,

Could you please let me know how to remove spaces in a dataset using syncsort.

Thank you.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19245
Location: Inside the Matrix

PostPosted: Fri Oct 18, 2013 7:19 pm
Reply with quote

Hello,

Post some sample input data and the output you want from that data when your process is run.

Mention the recfm and lreckl of the input/output.
Back to top
View user's profile Send private message
viji_rags

New User


Joined: 04 Jun 2010
Posts: 24
Location: chennai

PostPosted: Fri Oct 18, 2013 7:23 pm
Reply with quote

Hi,

If the input of the file is as below and the output file should not contain spaces.

Code:
input:
¦"ABCD         "¦"10      "¦"+         0.00000000000"¦

output:
¦"ABCD"¦"10"¦¦"+0.00000000000"¦

Code'd
recfm=FB
lreckl =810
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Fri Oct 18, 2013 7:32 pm
Reply with quote

viji_rags, please post data, code, and anything else for which alignment may be significant in Code tags; as you will see for yourself, posting without them makes it very difficult to discern where the spaces are.
Back to top
View user's profile Send private message
viji_rags

New User


Joined: 04 Jun 2010
Posts: 24
Location: chennai

PostPosted: Fri Oct 18, 2013 7:38 pm
Reply with quote

Hi,

Consider underscore as spaces. The spaces needs to be removed.

input:
¦"A_______"¦"1234___"¦"+____1.00"¦

output:
¦"A"¦"1234"¦"+1.00"¦

Thanks,
Vijay
Back to top
View user's profile Send private message
Ramsee

New User


Joined: 06 Jan 2011
Posts: 53
Location: Chennai

PostPosted: Fri Oct 18, 2013 7:44 pm
Reply with quote

Hi,

Please try the instruction given in the below link:

ibmmainframes.com/about47710.html

Let me know if you still need assistance.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19245
Location: Inside the Matrix

PostPosted: Fri Oct 18, 2013 8:46 pm
Reply with quote

Hello,

Your original post has been "Code'd". You need to use the code tag when posting anything that needs to retain alignment.

Coded, your info looks like:
Code:
input:
¦"ABCD         "¦"10      "¦"+         0.00000000000"¦

output:
¦"ABCD"¦"10"¦¦"+0.00000000000"¦


Let us know how the solution in the posted link works for you.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts rexx pgm to create multiple ps file IBM Tools 7
No new posts Remove commas from specific positions... DFSORT/ICETOOL 10
No new posts Uploading from desktop, a CSV file, s... DB2 2
No new posts SYNCSORT/ICETOOL JOINKEYS SORT Statem... DFSORT/ICETOOL 13
No new posts How to fill with zeroes pd intended s... DFSORT/ICETOOL 6
Search our Forums:

Back to Top