I need to squeeze out blanks, but one space between the words in two field, the field length should remain same and to do this on records after header (header first 2 line).
File Layout:
SRNO- 10
NAME- 10
DESC- 30
COMMENT - 30
For Ex:
In field DESC and COMMENT the values are like this
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Your description is rather confusing and you mention two headers that you don't show in your example, but if you want to squeeze out all but one blank between fields starting with record 3, you can use a DFSORT job like this:
Hi Frank,
Sorry for the confusion, will give you an example below with some more clarity...
More than one blank should be squeezed in DESC and COMMENTs only, Field length is DESC (from 21 to 50 (30)), COMMENTS (from 51 to 80 (30) ), Header two line.
INPUT FILE:
Code:
SRNO NAME DESC COMMENTS
***************************************************************
01 XXX ABC RES TYU AAA BBB CCC
02 YYY ADD WE DDDDD DD
NO XXXX FF XXXX
03 ZZZ TTTTT RRR R
OUTPUT FILE:
Code:
SRNO NAME DESC COMMENTS
*************************************************************
01 XXX ABC RES TYU AAA BBB CCC
02 YYY ADD WE DDDDD DD
NO XXXX FF XXXX
03 ZZZ TTTTT RRR R