Use of AWK as array


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Use of AWK as array
# 8  
Old 08-22-2008
In awk programs you cannot execute commands directly like in shell.
You must use the system function (or the getline command if you want to retreive the output of the command).
Code:
awk -v Q="'" '{bts[NR]=$1;tre[NR]=$2;bss[NR]=$3}
END{for (i=1;i<=NR;i++){ system("omcdo -cmd" Q "TRE_reset(" bts[i] "," bss[i] ",\"" tre[i] "\")" Q) } }' Output_TRE_ALARM.txt

In fact, you don't need to use arrays. You can do :
Code:
awk -v Q="'" '{ system("omcdo -cmd" Q "TRE_reset(" $1 "," $3 ",\"" $2 "\")" Q) ' Output_TRE_ALARM.txt

Jean-Pierre.
# 9  
Old 08-22-2008
Actually it seems like the first unknown is already the "omcdo". It isn't a built-in awk function name; if it's an external program, you need to invoke it with the system() function or something. Or you could simply use awk to print out the command line(s) you want executed, and pipe the output to sh

Last edited by era; 08-22-2008 at 11:13 AM.. Reason: Oops, Aigles got here first
# 10  
Old 08-25-2008
Data

Dear Friends,

Thank you very much for your comments.

But still i have some error:

To reset a TRE i have to use below mentioned command, under command prompt:which is a build in function for me.

omcdo -cmd 'TRE_reset(21,6,"24")'

I have to insert these three values from a file contains hundreds of values:
For example file : Output.txt

21 6 24
4 5 31
22 4 7
12 5 21
16 8 7
19 6 23

I need a script that extract values in array from file Output.txt and insert it in TRE build in function like above:

Please help me in this regard


Thanks a lot.SmilieSmilieSmilie
# 11  
Old 08-25-2008
You can do something like that (without array) :
Code:
while read V1 V2 V3
do
   omcdo -cmd \'TRE_reset($V1,$V2,"$V3")\'
done < Output.txt

Jean-Pierre.
# 12  
Old 08-25-2008
Error

BOSS!!! Still not working
Below is the test script

#/usr/sbin/ksh
set -x

while read V1 V2 V3
do
omcdo -cmd \'TRE_reset($V1,$V2,"$V3")\'
done < Output.txt


Its gives error message as given below:
./test.sh: line 6: syntax error near unexpected token `('
./test.sh: line 6: ` omcdo -cmd \'TRE_reset($V1,$V2,"$V3")\''


Please Reply
Thanks a lot in advance
# 13  
Old 08-25-2008
Try :
Code:
#!/usr/sbin/ksh
set -x

while read V1 V2 V3
do
omcdo -cmd "TRE_reset($V1,$V2,\"$V3\")"
done < Output.txt

Jean-Pierre.
# 14  
Old 08-25-2008
Question

Dear aigles,



Still i have same error:

To reset a TRE i have to use below mentioned command, under command prompt:which is a build in function for me.
actual command:
omcdo -cmd 'TRE_reset(21,6,"24")'

I have to insert these three values from a file contains hundreds of values:
For example file : Output.txt

21 6 24
4 5 31
22 4 7
12 5 21
16 8 7
19 6 23

I need a script that extract values in array from file Output.txt and insert it in TRE build in function like above:

Please help me in this regard
Thanks a lot.
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

array in awk

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=$LINE ((count++)) done #close file exec 10>&- ENDLOOP=0 (10 Replies)
Discussion started by: rocket_dog
10 Replies

8. 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

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