Splitting a file based on record sin another file - UNIX for Dummies Questions & Answers

Franklin52 · #5 (**permalink**) 05-13-2008

Code:

awk 'NR==FNR{a[substr($0,1,5)];next}

Gets first 5 characters of the first file into array.

Code:

 NF<3{next}

Ignore lines with less then 3 fields (the first and last line)

Code:

 substr($1,2,5) in a {print > "file1";next}

If 5 characters after quotes in array print to file1..

Code:

 {print > "file2"}

... else print to file2

The original files should not change.

Regards