Many thanks, I'll try your new code right away and let you know asap.
I think if a group is missing for all groups blocks won't be a problem because it'll mean that only exist those groups that appear as unique Groups in the
file.
Best regards
---------- Post updated at 09:20 PM ---------- Previous update was at 08:21 PM ----------
Tested and works independently. Now I'll test it including it in my main awk script and following the structure of code as you suggested me. I'll let you know
Many thanks.
---------- Post updated at 11:00 PM ---------- Previous update was at 09:20 PM ----------
Hi again agama,
Is possible to process file1 first? how would be the structure?
I ask this because when awk code is processing file2 generates another array, but doing comparison with one of the arrays created when the code reads file1.
I've tried change the order as follow, but doesn't work (changes in red):
Thanks again for your help
---------- Post updated 10-24-11 at 05:21 AM ---------- Previous update was 10-23-11 at 11:00 PM ----------
Hi agama again,
I've been able to adapt your code and suggestions into my main code. I saw that was much more complicated to
generate the array in the same awk code, then I generated an array and stored data in bash array. This bash array
is the input to main awk code.
At the beginnig I had some issues, but I was able to set the correct format of the array expected by the split() function.
The final code is as below:
Many thanks again both for all help and time.
Yes, it would have been possible to generate the array's before the processing of the second file.... You would have just needed to change END { to a function (something like function gen_array() {) and then invoke it once at the start of the second file:
Doubt you'll go back and make the changes (I wouldn't once I had something working), but figure I'd post it for some closure here.
Even when I could adapt your code to the main awk code with success using a bash array, It would be great to know how would be the way you say using the function.
It works faster than the other way because all is in awk and I dont need anymore at least 2 arrays that I was generating before.
I've learn many things with this thread, I'm some new to awk, but completely new with awk UDF functions. I have now better idea in how to use them.
At the end I'm not sure why if I use the structure of "NR != FNR" is not working for me, It worked great in this way:
Many thanks again for your great help, support and time.
Hello,
I have searched but failed to find what exactly im looking for,
I need to eliminate first "." in a output so i can use something like the following
echo "./abc/20141127" | nawk '{gsub("^.","");print}'
what i want is to use gsub result later on, how could i achieve it?
Let say... (4 Replies)
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)
Hi everybody
I wanna store some values that r in a .txt file in some arrays
for example I have:
32782 28
32783 02
32784 01
32785 29
32786 25
32787 25
32788 00
32789 25
32790 02
32791 29
32792 23
32793 01
32794 28
and I need to save the first... (4 Replies)
I want to create an array which can store the strings from the user input in shell script .
example :-
I want to store the 5 fruits name in a single array which the user provides . (1 Reply)
I want to pass an array of variables to be inserted by awk in the 2nd column of a file.
Empl No. Employee Age
1000000 22
1100000 24
1200000 26
Now, I want to pass an array having three different ages which need to replace the... (7 Replies)
Dear all,
I have a file having the following formats:
ThreadFail=Web1=1234
ThreadFail=Web2=2345
ThreadFail=Web3=12
ConnectionFail=DB1=11
ConnectionFail=DB2=22
The number of lines will be different from every time . How can I parse the file and store the result to an a array inside... (6 Replies)
I am trying to assign a awk array for further processing later in the script. I can't seem to figure it out. If someone could look at this and help me, I would very much appreciate it.
Thanks in Advance.
for ( x = 1 ; x <= Var ; x++ ) {
if ( x in varr ) {
... (2 Replies)
:)
Suppose,I have one table A. Table A have one column. Table A have 10 rows. I want this 10 rows store into shell script variable.
like
#!/bin/ksh
v_shell_var=Hi
here in call oracle , through loop How can I store table A's 10 rows into v_shell_var (Shell Script Array).
Regards,
Div (4 Replies)