awk problems


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users awk problems
# 1  
Old 10-09-2007
awk problems

awk ' FILENAME=="First"{
arr[$1] = 1;
x=sub[$2] ;
}
FILENAME=="Second"{
if (/^10/ && arr[substr($0,31,5)]){
sub(substr($0,4,5),$x,$0);
print $0 ;
}
}
' First Second

the problem that I want to access the VAR X from the first file to modify the second file if the (IF expression is true)

the first problem :how can we solve this

the second problem : if we have several files as the second but the first is fixed how can we get the files automatically

here is an example of the files

the first file:
04756 23644
02565 25696
25698 25693


the second files:
10023658702365970000236587000204756
20002655000002365900000255
10002365000002365000002566900000225

thanks in advance
# 2  
Old 10-10-2007
any body replay guys

can any body feed me if its possible or not;
# 3  
Old 10-10-2007
the idea from this program is to make match between the two files by using the first field from the first file
and after match make some modify by using the second field from the first file

as the example above the bold number in the first file (first field) must match the last bold number on the second file and if its match modfy the second file depending on the second field on the first file

regards
i hope i will recieved any respond
# 4  
Old 10-10-2007
You could find a very similar thread here
# 5  
Old 10-10-2007
Quote:
Originally Posted by Ehab
the idea from this program is to make match between the two files by using the first field from the first file
and after match make some modify by using the second field from the first file

as the example above the bold number in the first file (first field) must match the last bold number on the second file and if its match modfy the second file depending on the second field on the first file

regards
i hope i will recieved any respond

Please read the rules of the forum Smilie

Do not bump up questions !
# 6  
Old 10-10-2007
Quote:
Originally Posted by Ehab
the idea from this program is to make match between the two files by using the first field from the first file
and after match make some modify by using the second field from the first file

as the example above the bold number in the first file (first field) must match the last bold number on the second file and if its match modfy the second file depending on the second field on the first file

regards
i hope i will recieved any respond
I can understand the first block of your requirement.

But from where does this number - 23658 come from ?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Execution Problems with awk

Ubuntu, Bash 4.3.48 Hi, I have this input file: a1:b2:c30:g4:h12:j7 and I want this output file: a1=g4:b2=h12:c30=j7 I can do it this with this code: awk -F':' '{print $1"="$4":"$2"="$5":"$3"="$6"}' INPUT > OUTPUTIn this case I have 6 columns, I calculate manually the half number of... (6 Replies)
Discussion started by: echo manolis
6 Replies

2. Shell Programming and Scripting

Having Problems with AWK

So, I'm having a lot of crazy problems with Awk that I cannot understand. This one in particular is driving me nuts. Here is one section of my Awk script: print $0 sub(/Jan/,"",$2) sub(/Feb/,"",$2) sub(/Mar/,"",$2) sub(/Apr/,"",$2) sub("May","",$2) ... (5 Replies)
Discussion started by: rrdein
5 Replies

3. Shell Programming and Scripting

awk problems - awk ignores conditions

awk 'BEGIN{ if('"$CATE"'<'"${WARN}"') printf ("%s", "'"`Kfunc "" ; break`"'") else if (('"${CATE}"'>='"${WARN}"') && ('"${CATE}"'<'"${CRIT}"')) printf ("%s", "'"`Wfunc ""; break`"'") else if ('"${CATE}"'>='"${CRIT}"') printf... (6 Replies)
Discussion started by: SkySmart
6 Replies

4. Shell Programming and Scripting

simple problems in awk

Dear All, I have the following awk script. #!/bin/bash sh stdev.cmd data.file | awk '{print $2}' > out.data read d < out.data echo $d awk '{print $1,$2- $f}' new > newz The script runs "stdev.cmd" and output a file "out.data" and the value of the... (2 Replies)
Discussion started by: Yacob_123
2 Replies

5. UNIX for Dummies Questions & Answers

Problems with AWK

Hi I am writing a shell script for a number of things and aone problem that keeps comming up is AWK formatting. When commands are typed into the command line they are fine, but when executed in the script the results are pilled up and not in a list/table format. I have tried using ... (2 Replies)
Discussion started by: AngelFlesh
2 Replies

6. Shell Programming and Scripting

Execution problems using awk command.

Hi All, I have the following requirement. In a directory i get files from external source. I at regular intervals check that directory for any incoming files. The file name is underscore delimited. Such as: aaa_bbb_ccc_ddd_eee_fff.dat I am using awk and and splitting the file name. ... (4 Replies)
Discussion started by: satishpv_2002
4 Replies

7. UNIX for Dummies Questions & Answers

problems with awk

Using Linux, I am trying to create a list of all the lines that have "Non-white" or "No" in column 3 of a file: ethnicity.txt. I have used the following command : awk '$3 == "No" || $3 == "Non-white" {print $1, $2, $3}' ethnicity.txt This only returns the lines with "No" and none of... (3 Replies)
Discussion started by: polly_falconer
3 Replies

8. Shell Programming and Scripting

help.. Problems in using awk

I do have a file (named as templist) which looks like this one: 00450000.000000 00402300.000000 00040000.000000 00020000.000000 00020000.000000 00020000.000000 00020000.000000 and I want to make a script that adds this using AWK or FOR. I tried using awk using the command but it just... (8 Replies)
Discussion started by: dakid
8 Replies

9. Shell Programming and Scripting

awk problems

If i try the -f option for awk, i get the "awk: can't open " error message The following awk statement works fine without the -f option `awk <$RULES '/^IGNORE_POLICY / { print $2 }'` Below how i turned on debugging to show what is happening, can someone provide me with some advice!!!! ... (1 Reply)
Discussion started by: Junes
1 Replies

10. Shell Programming and Scripting

Problems with AWK

Hi I'm a newbie to Unix scripting and was having some problems with AWK. I have written this little script that should read a process list and then print out the PID's of the offending processes. Unfortunately it doesn't seem to work! The script is as follows: ps -ef | awk '{if... (10 Replies)
Discussion started by: trainee
10 Replies
Login or Register to Ask a Question