Omit the records which are spaces

sandra · New User Joined: 06 Apr 2005 Posts: 27

I have a file in which there are thousands of records and some of the records are spaces. How can I put in the condition to remove blank records in the file?

krisprems · Posted: Sat Jun 16, 2007 6:56 pm

sandra

Is there any mandatory(key) field in your file, that which cannot be blank?
If so, use a sort card to add an omit cond to check if the filed is blank.

Also what is lrecl and RECFM of the file?

dick scherrer · Posted: Sat Jun 16, 2007 8:09 pm

Hello,

If i understand the question, there are records that are entirely blank. Even if the blanks are only in particular positions, those can be bypassed also.

No sort key should be needed to OMIT those, just the place(s) where the blanks are not wanted.

Also, if you specify COPY rather than SORT you will preserve the current sequence and have a new file with the blank records removed and it will run faster than sorting..

Frank Yaeger · Posted: Mon Jun 18, 2007 8:41 pm

Sandra,

What is the RECFM and LRECL of your input file?

dick scherrer · Posted: Mon Jun 18, 2007 11:54 pm

Hello Sandra,

You're welcome

As Frank asks

sandra · New User Joined: 06 Apr 2005 Posts: 27

What is the RECFM and LRECL of your input file?

recfm=FB and LRECL=120

ParagChouguley · Posted: Thu Jun 21, 2007 11:07 am

Hi,

Frank Yaeger · Posted: Thu Jun 21, 2007 8:31 pm

Notice that you only need one blank in the constant - C' '. DFSORT pads a character constant with blanks on the right to match the length of the field, so in this case it pads the constant from 1 blank to 120 blanks. Saves a lot of typing.