Shell Programming and Scripting

Code:

awk 'NR==FNR{a[$0]; next} $6 in a{print > "/dir/to/" $6 "/newfile"}' /path/to/arrayfile file

It's unnecessary to use the script, the single awk command should do the whole job.

Maybe I am explaining it wrong. I have a text file that has multiple lines that are all formatted the same and the text is separated by a tab. Below is an example of this text file:

Code:

TEXT1A	TEXT2A	TEXT3A	TEXT4A	TEXT5A	TEXT6A	TEXT7A
TEXT1B	TEXT2B	TEXT3B	TEXT4B	TEXT5B	TEXT6B	TEXT7B
TEXT1C	TEXT2C	TEXT3C	TEXT4C	TEXT5C	TEXT6C	TEXT7C

I want to search each line in this file to see if the text field #6 matches the line I am searching for. I want to search from an array file one by one until done. See an example of the array file below:

Code:

TEXT6A
TEXT6B
TEXT6C

When a match is found, I want to print the entire line where that match was found to a file in a folder named after the text that I am searching for. For example, I want to write the whole line where the match occurred to /dir/to/TEXT6A/file.

I could not get the following to print the lines where the match occurred:

[QUOTE=Franklin52;302523738]

Code:

awk 'NR==FNR{a[$0]; next} $6 in a{print > "/dir/to/" $6 "/newfile"}' /path/to/arrayfile file

Please advise.

how exactly does the solution provided by Franklin52 not solve the issue?
what exactly does not work?

My mistake It works.

---------- Post updated at 09:56 PM ---------- Previous update was at 04:23 PM ----------

Upon further investigation I noticed that I still had the problem when working with real world data although all the tests worked fine.

The code below supplied by Franklin52 is correct although I need one modification

Code:

awk 'NR==FNR{a[$0]; next} $6 in a{print > "/dir/to/" $6 "/newfile"}' /path/to/arrayfile file

This code looks for the 6th field separated by spaces and tabs. When working with real world data, some fields contain spaces within the field and when these spaces exist this command doesn't work. I need to know how to modify the above command to look at the 6th field separated by tabs so it does not get confused when a space is introduced within a field.

Test sample file:

Code:

TEXT1A	TEXT2A	TEXT3A	TEXT4A
TEXT1B	TEXT2B	TEXT3B	TEXT4B
TEXT1C	TEXT2C	TEXT3C	TEXT4C

Real world file;

Code:

TEXT1A	TE XT2A	TEXT3A	TEXT4 A
TEXT1B	TE XT2B	TEXT3B	T EXT4B
TEXT1 C	TEXT2C	TEXT3C	TEXT4C

Thanks in advance.

---------- Post updated 05-20-11 at 12:24 AM ---------- Previous update was 05-19-11 at 09:56 PM ----------

I solved it. See below for the solution:

Code:

awk -F'[\t]' 'NR==FNR{a[$0]; next} $6 in a{print > "/dir/to/" $6 "/newfile"}' /path/to/arrayfile file