Hi I am trying to get data from an array and input it into awk. Please see below:
###
#!/bin/bash
#declare array
declare -a ARRAY
exec 10</path/to/arrayfile
let count=0
while read LINE <&10; do
ARRAY[$count]=$LINE
((count++))
done
#close file
exec 10>&-
ENDLOOP=0
i=0 ;
y=$((${#ARRAY[@]} - 1)) ;
until [ $i -gt $y ] ;
do
echo -e "Sorting ${ARRAY} ... " ;
cat file | awk 'BEGIN { FS= "[\t]" }; { if ($6 = "${ARRAY}" ) print $0}' > /dir/to/${ARRAY}/newfile ;
((i++)) ;
done
###
I am expecting the array to search for the first entry in the array file at a specified field seperated by tabs, then the second, then the third although it does not seem to be working properly and I believe my syntax is incorrect. Any help would be greatly appreciated.
#!/bin/bash
#declare array
declare -a ARRAY
exec 10</path/to/arrayfile
let count=0
while read LINE <&10; do
ARRAY[$count]=$LINE
((count++))
done
#close file
exec 10>&-
ENDLOOP=0
i=0 ;
y=$((${#ARRAY[@]} - 1)) ;
until [ $i -gt $y ] ;
do
echo -e "Sorting ${ARRAY} ... " ;
cat file | awk 'BEGIN { FS= "[\t]" }; { if ($6 = "${ARRAY}" ) print $0}' > /dir/to/${ARRAY}/newfile ;
((i++)) ;
done
The expected result is that the loop will first check field 6 for the text "text1" and if "text1" is in that field, print the entire line to /dir/to/text1/newfile. Then the same for "text2" and "text3". If I replace ${ARRAY[i]} with text1, as seen below, I get the desired result:
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:
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:
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:
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.