How to remove spaces between variables using SORT?

Selvarajars · New User Joined: 21 Jun 2018 Posts: 7 Location: India

Hi,

I need to remove spaces between variables. There is a possibility that single variable can have spaces in between, it should be removed.

Example:
I have a file which has records like below

123123 |ba12 12|jhajf afdjhsdakj asfdkjhkj |kashfdjhas |

My output should be something like this.

123123|ba12 12|jhajf afdjhsdakj asfdkjhkj|kashfdjhas|.

I have a delimiter as pipe symbol. The record length I am using is 1999, but still I will not get values upto 1999.

Could someone help me asap.

Thanks in advance.

Regards,
Selva N

Nic Clouston · Posted: Fri Jul 27, 2018 4:15 pm

What you want to do cannot be done by JCL. JCL does not manipulate data, it simply tells the OS that you want to run a program and the resources needed to do so. It is, also, not a VSAM question. Given those two points, why post in the JCL & VSAM part of the forum.
Topic moved to DFsort part of the forum because it can do what you want. If you do not have DFSort but have SyncSort then let us know and it will be moved to the taht part of the forum.

Look in the manual for something like "Spaces, Removing" in the index and SQZ.

Rohit Umarjikar · Posted: Fri Jul 27, 2018 4:48 pm

Have you even tried once to Google this? If not then please do so since you will get many links and different ways how this is achieved.

Selvarajars · New User Joined: 21 Jun 2018 Posts: 7 Location: India

Hi Nic,

Thanks for your guidance.

I tried with SQZ and it is not working. Can you please help me with the Manual you are referring.

Thanks.

Regards,
Selva N

Rohit Umarjikar · Posted: Fri Jul 27, 2018 4:58 pm

ibmmainframes.com/about65464.html

Selvarajars · New User Joined: 21 Jun 2018 Posts: 7 Location: India

Hi Rohit,

Thanks a lot. Let me try this.

Regards,
Selva N

Arun Raj · Posted: Fri Jul 27, 2018 6:28 pm

You might want to take a look at this one.

ibmmainframes.com/about47014.html

sergeyken · Posted: Fri Jul 27, 2018 10:58 pm