how to removes spaces in file using sorT?

[Neeraj Mehta]

Hi Everyone,

Does anyone know how to removes spaces in file using sort.

I have a file which record length is 2000. I need to trim all the areas which has spaces in the file. For example, if I have data like 'XXXXX   111 YYY' then output should be 'XXXXX111YYY'.

The only thing is we don't know at which position we might have spaces

[Anuj Dhawan]

Try, untested:

Code: Select all

SORT FIELDS=COPY
INREC BUILD=(1,80,SQZ=(SHIFT=LEFT))

 

[enrico-sorichetti]

sorry ...
while the answer might be - at the lowest level of technicalities - correct
it was rushed ...
we do not know anything about the TS environment and the cconsequence of an unconditional shift of all the data

wiser for the ts to repost/clarfify  the question with a few more details ...
for example is the dataset FB vs. VB  ( record length is 2000 )


 

[Anuj Dhawan]

Agree, it was rushed.

[Neeraj Mehta]

Thanks, this has worked for me.