Remove trailing SPACES using SORT.

[BobThomas]

Hi,

From an input file I want to remove the trailing spaces after the value of the filed and before the commausing SORT. For example, please consider the data like this:

Code: Select all

11,A B C D ,abc  , 
12,xxyy zz ,xyz  some place   , 
13,xxyz ,xyz  other avenue , 

The output file should like this:

Code: Select all

11,A B C D ,abc, 
12,xxyy zz ,xyz  some place, 
13,xxyz ,xyz  other avenue, 

Could anyone please suggest a way of doing this?

[nicc]

Will it always be the same number of fields? Your example shows each record having 3 fields.

[BobThomas]

Thanks for the answer. Yes, it will always be same number of fields.

[William Collins]

Use FINDREP to change C' ,' to C''

[BobThomas]

But that removes the sapce for second field also, I want to remove teh sapce for third filed only.

[William Collins]

Sorry, missed that part as it only appeared with the data :-)

Two techniques. Use FINDREP with DO=2 to change comma to X'FD' (or any non-display value). Use FINDREP to change the spaces-and-comma (you'll need multiple, it looks like, as you don't have a fixed number of trailing spaces). This can be DO=1. Use FINDREP again to change the non-display value back to comma (DO=2).

Use JFY. SHIFT=RIGHT to maximum record-length. SHIFT=RIGHT to entire record except the "." which is in the right-most position. SHIFT=LEFT for the entire record.

[BobThomas]

Thank you.