I have a file (FB - RECL - 72), with first 3 fields of 22 bytes each and last with 6 bytes. First 3 fields have data (alphanumeric) which may/may not start from first position. The message can be of any length (from 0 to 22, 0 since Field 1 and 3 can be non-empty where 2 can be empty)
I need to strip off the extra spaces before and after the actual message, so that I can have the message in a single line without leading and trailing spaces. But the intermediate space characters should be preserved. Fourth field should not be affected, and retained in same position as in input.
I need 1 blank space between the messages in the output file.
Input File :-
Code:
---------------------- ---------------------- ----------------------- ------
HI EVERYBODY. THIS IS A SAMPLE DATA TO FIND AAAAAA
IF WE CAN JUSTIFY A RECORD, WITHOUT SQUEEZE BBB
Output File :-
Code:
-------------------------------------------------------------------------
HI EVERYBODY. THIS IS A SAMPLE DATA TO FIND AAAAAA
IF WE CAN JUSTIFY A RECORD, WITHOUT SQUEEZE BBB
I tried Squeeze Option, where the intermediate spaces were removed. Please suggest.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Assuming that the first field starts in position 1, the second field starts in position 23, the third field starts in position 45 and the fourth field starts in position 67, here's a DFSORT job that will do what I think you're asking for. (I also assumed there aren't any apostrophes in your messages.)
But sorry, I should have said that my data contains all forms of special characters.. including Single/Double quotes.. (My data contains addresses, where we cannot restrict the special characters). I went for an option of X'0505' instead of C''''.. Not sure if it is advisable..
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
I should have said that my data contains all forms of special characters.. including Single/Double quotes
The technique I used requires the use of PAIR=APOST (for apostrophes) or PAIR=QUOTE (for double quotes). So apostrophe or double quote are the only characters that will work as the leading and trailing characters with this technique. If your data can contain both apostrophes and double quotes as well as embedded blanks, then I don't see any way of doing what you want with IFTHEN.
.jpg)
