Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

array in awk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting array in awk
# 1  
Old 05-19-2011
Lightbulb array in awk
Hi I am trying to get data from an array and input it into awk. Please see below:

Code:
###
#!/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[i]} ... " ;
  cat file | awk 'BEGIN { FS= "[\t]" }; { if ($6 = "${ARRAY[i]}" ) print $0}' > /dir/to/${ARRAY[i]}/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.
Moderator's Comments:
Mod Comment Please use code tags when posting data and code samples!
Last edited by rocket_dog; 05-19-2011 at 12:25 PM.. Reason: code tags, please!
# 2  
Old 05-19-2011
Please provide a sample input file and a desired output (using code tags).
# 3  
Old 05-19-2011
Your approach is very inefficient, is something like this what you're looking for?
Code:
awk 'NR==FNR{a[$0]; next} $6 in a' /path/to/arrayfile file > /dir/to/${ARRAY[i]}/newfile


BTW: the shebang (#!/bin/bash) must be one the first line of a shell script.
# 4  
Old 05-19-2011
use this line:
Code:
cat file | awk 'BEGIN { FS= "[\t]" }; { if ($6 = '"${ARRAY[i]}"' ) print $0}' > /dir/to/${ARRAY[i]}/newfile ;

# 5  
Old 05-19-2011
See /path/to/arrayfile below
Code:
text1
text2
text3

Code:
#!/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[i]} ... " ;
  cat file | awk 'BEGIN { FS= "[\t]" }; { if ($6 = "${ARRAY[i]}" ) print $0}' > /dir/to/${ARRAY[i]}/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:
Code:
cat file | awk 'BEGIN { FS= "[\t]" }; { if ($6 = "text1" ) print $0}' > /dir/to/${ARRAY[i]}/newfile ;

# 6  
Old 05-19-2011
Try this:
Code:
awk 'NR==FNR{a[$0]; next} $6 in a{print > "/dir/to/" $6 "/newfile"}' /path/to/arrayfile file

# 7  
Old 05-19-2011
I tried the following with no luck:
Code:
awk 'NR==FNR{a[$0]; next} $6 in a{print > "/path/to/${ARRAY[i]}/" $6 "/newfile"}' /path/to/arrayfile file

could there be an issue with the syntax in the way I am using ${ARRAY[i]} as in /path/to/${ARRAY[i]}/ ?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

awk array

Hello. I'm trying to figure out which one of these is not true about an awk array. -You do not need to formally declare an array; it is created automatically on first assignment -Array elements can only be addressed using an index ... (1 Reply)
Discussion started by: Eric7giants
1 Replies

2. Shell Programming and Scripting

awk loop using array:wish to store array values from loop for use outside loop

Here's my code: awk -F '' 'NR==FNR { if (/time/ && $5>10) A=$2" "$3":"$4":"($5-01) else if (/time/ && $5<01) A=$2" "$3":"$4-01":"(59-$5) else if (/time/ && $5<=10) A=$2" "$3":"$4":0"($5-01) else if (/close/) { B=0 n1=n2; ... (2 Replies)
Discussion started by: klane
2 Replies

3. Shell Programming and Scripting

How to Assign an shell array to awk array?

Hello All, Can you please help me with the below. #!/bin/bash ARR="No Differences In Stage Between HASH_TOTALS & HASH_TOTALS_COMP For UNINUM:0722075 PROVIDER:5 EXTRACT_DT:30-SEP-12 VER_NUM:1" ARR="No Differences In Stage Between HASH_TOTALS & HASH_TOTALS_COMP For UNINUM:0722075 PROVIDER:5... (14 Replies)
Discussion started by: Ariean
14 Replies

4. Shell Programming and Scripting

Array from awk

I'm trying to get the output from awk into a bash array. Here is my script. #!/bin/bash while : do app=$( osascript -e "tell application \"System Events\" to return name of every process whose frontmost is true" ) echo "$app" if ava ]] then ps -ax | grep -v awk | pids=( $(awk... (5 Replies)
Discussion started by: nextyoyoma
5 Replies

5. Shell Programming and Scripting

HELP with AWK one-liner. Need to employ an If condition inside AWK to check for array variable ?

Hello experts, I'm stuck with this script for three days now. Here's what i need. I need to split a large delimited (,) file into 2 files based on the value present in the last field. Samp: Something.csv bca,adc,asdf,123,12C bca,adc,asdf,123,13C def,adc,asdf,123,12A I need this split... (6 Replies)
Discussion started by: shell_boy23
6 Replies

6. Shell Programming and Scripting

array in awk

hi, can somebody explain me this? probably i am overlooking something but i dont know what why is not printed "7 9 11" instead of this? $ echo "" | awk '{for(i=1;i<=3;i++){j=7;a=j;j=j+2;} print a,a,a; }' 7 7 7thanks (2 Replies)
Discussion started by: erik80
2 Replies

7. Shell Programming and Scripting

AWK help. how to compare a variable with a data array in AWK?

Hi all, i have a data array as follows. array=ertfgj2345 array=456ttygkd . . . array=errdjt3235 so number or elements in the array can varies depending on how big the data input is. now i have a variable, and it is $1 (there are $2, $3 and so on, i am only interested in $1). ... (9 Replies)
Discussion started by: usustarr
9 Replies

8. Shell Programming and Scripting

Use of AWK as array

Dear Experts, I have a file containing text like below 123 456 789 012 345 I want to save each line in array. and print each array index as per my requirement. For Example array will print 456 array will print 012 Thanks for your Help. (14 Replies)
Discussion started by: Danish Shakil
14 Replies

9. Shell Programming and Scripting

array on awk

I have a raw data file: 70,1,1,-53.25 70,1,1,,,,-57.50 70,1,1,,,,,,,,,,-48.00 I want to have a output file with the formatting below: 70,1,1,-53.25,,,,-57.50,,,,,-48.00 I mean if these rows have the first similar three variables which will be group into one row. And I try to write a... (1 Reply)
Discussion started by: anhtt
1 Replies

10. Shell Programming and Scripting

Array in awk

Hi, How can find Array is NULL or not. i wrote script using arrays but i want dislpy an message if arrary was Empty. pls help me on this. (2 Replies)
Discussion started by: koti_rama
2 Replies
Login or Register to Ask a Question