How to remove spaces in a file using sync sort

viji_rags · New User Joined: 04 Jun 2010 Posts: 24 Location: chennai

Hi,

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

Thank you.

dick scherrer · Posted: Fri Oct 18, 2013 7:19 pm

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.

viji_rags · New User Joined: 04 Jun 2010 Posts: 24 Location: chennai

Hi,

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

Akatsukami · Posted: Fri Oct 18, 2013 7:32 pm

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.

viji_rags · New User Joined: 04 Jun 2010 Posts: 24 Location: chennai

Hi,

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

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

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

Thanks,
Vijay

Ramsee · New User Joined: 06 Jan 2011 Posts: 53 Location: Chennai

Hi,

Please try the instruction given in the below link:

ibmmainframes.com/about47710.html

Let me know if you still need assistance.

dick scherrer · Posted: Fri Oct 18, 2013 8:46 pm

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: