Selecting record based on a condition 1

[mwesticle]

Hi... I have a file that contains name and address information. The primary address appears from byte 116-150. I need to pull all records off of that file where primary address is NOT blank, and put them into a new file. Can anyone help me out here???

 

[Salem]

Something like

awk 'substr($0,116,35) != "" { print }' file > newfile

--

 

[CaKiwi]

Not tested, but try

awk 'substr($0,116,35) ~ /[^ ]*/' infile > outfile

CaKiwi

 

[mwesticle]

Well... I tried all the solutions... The two awk examples don't work for me because i need to pull off all records that have spaces in the primary address field. The shell example pulls off all records where primary address is blank, which is the opposite of what i need. Anyonw know how I could flip that around???

 

[olded]

Sorry, misread your requirement:

#!/bin/ksh

while read record
do
x=$(echo "$record"|cut -c116-150)
case $x in
+([ ]))
continue;;
*)
echo "$record" >> newfile;;
esac
done < oldfile