for loop for 2nd field of 1st and 2nd column...with a length of file 2's number of lines
Code:
for(j=1;j<=file2's length,j++)
now for loop like this for
Code:
(i=1;i<file1's array length;i++)
comparison
Code:
if lt[i] >=calc1 && lt[i]<=calc2
following if statements
else increment i and again check condition,
once i length reaches file1's array length
print file2's column fields..
then increment of j in 1st for loop
my script is having some mistakes...as I don't know much about either awk or shell...so I could not find where is problem....those who know, please solve my problem
this is printing data
but, data is not in file2, it was suppose to print data from file 2 I really don't know what mistake I am doing here....
pls explain if you find my mistake, I guess might be in array
output looks like this
Code:
68.14 23.48 You are in
67.62 23.04 You are in ------->wrong 23.04 not exist in file2
67.68 23.09 You are in -------> file1 data is printing
67.73 23.14 You are in -------> again wrong result...
67.79 23.19 You are in
67.85 23.24 You are in
67.91 23.28 You are in
67.97 23.33 You are in
68.02 23.38 You are in
68.08 23.43 You are in
67.56 22.99 You are in
67.13 22.54 You are in
this is printing data
but, data is not in file2, it was suppose to print data from file 2 I really don't know what mistake I am doing here....
pls explain if you find my mistake, I guess might be in array
output looks like this
Code:
68.14 23.48 You are in
67.62 23.04 You are in ------->wrong 23.04 not exist in file2
67.68 23.09 You are in -------> file1 data is printing
67.73 23.14 You are in -------> again wrong result...
67.79 23.19 You are in
67.85 23.24 You are in
67.91 23.28 You are in
67.97 23.33 You are in
68.02 23.38 You are in
68.08 23.43 You are in
67.56 22.99 You are in
67.13 22.54 You are in
I agree with Jim. You make us download two files to see that you have one file with spaces as field separators and another file with a tab as the field separator. You give us some awk code that contains no comments and does not do what you want it to do. You tell us that the comments in the if statements explain what you're trying to do (but as I said, there are no comments in your code). You ask us to guess at what you mean by "2 files need to be compared". We can't read your code and tell you what is wrong with it if we don't know what you're trying to do.
Please tell us what you are trying to do in English. Show us sample input and show us the output you want from that sample input. Don't show us that your code doesn't give you what you want; show us what you do want.
I just want to use this logic in shell awk script
1 . First read column 1 and column 2 of file1.txt store it in array(reference)
2 . Now read column 1 and column 2 of file2.txt store it in another array,to be compared with reference
3 . for loop : - for(i=1;i<=file2.txt_length;i++)
4 . x=0; y=0 this will get clear as and when i will increment
5 . nested loop :- for(j=1;j<=file1.txt_lenght;j++)
6 . if(col1_f1[j]>=col1_f2-0.1[i] && col1_f1[j]<=col1_f2+0.1[i])
if above if statement is true then,go to following statement else check condition with j++
7 . if(col2_f2[i]>=col2_f1[j]) then x=x+1
8 . if(col2_f2[i]<=col2_f1[j]) then y=y+1repeat 5,6,7 and 8 till j reaches file1.txt_length(NR),Once j reaches NR following
9 . if(x>=1 && y>=1) then print column1_f2[i] column2_f2[i] repeat statements after number 4 to 9 till i reaches file2.txt_length(NR)
I hope this will be helpful
this logic is to find whether file 2.txt is falling within the range of file1.txt(reference)
if falling, how many records are near to records of file1.txt
and this is for mapping purpose, one can see script's result preview in GMT, with reference file
I am trying to write the same logic in awk script, but I couldn't succeed..those who know...awk very well pls help
Thanks in advance.........................
Last edited by Akshay Hegde; 02-10-2013 at 09:53 AM..
Reason: ???? Awaiting for reply......
I just want to use this logic in shell awk script
1 . First read column 1 and column 2 of file1.txt store it in array(reference)
2 . Now read column 1 and column 2 of file2.txt store it in another array,to be compared with reference
3 . for loop : - for(i=1;i<=file2.txt_length;i++)
4 . x=0; y=0 this will get clear as and when i will increment
5 . nested loop :- for(j=1;j<=file1.txt_lenght;j++)
6 . if(col1_f1[j]>=col1_f2-0.1[i] && col1_f1[j]<=col1_f2+0.1[i])
if above if statement is true then,go to following statement else check condition with j++
7 . if(col2_f2[i]>=col2_f1[j]) then x=x+1
8 . if(col2_f2[i]<=col2_f1[j]) then y=y+1repeat 5,6,7 and 8 till j reaches file1.txt_length(NR),Once j reaches NR following
9 . if(x>=1 && y>=1) then print column1_f2[i] column2_f2[i] repeat statements after number 4 to 9 till i reaches file2.txt_length(NR)
I hope this will be helpful
this logic is to find whether file 2.txt is falling within the range of file1.txt(reference)
if falling, how many records are near to records of file1.txt
and this is for mapping purpose, one can see script's result preview in GMT, with reference file
I am trying to write the same logic in awk script, but I couldn't succeed..those who know...awk very well pls help
Thanks in advance.........................
Even with all of your color coding, this logic isn't clear to me. But, just looking at the 1st and last line of your 2nd awk script:
we can see that for every line you read from file2.txt, you replace $1 and $2 with a line from file1.txt and since file1.txt has many more lines than file2.txt, you are not reading all of file1.txt and you are not saving anything at all read from file2.txt.
The following awk program will perform steps 1 and 2 in your list above. You can build the rest of your steps into the END clause where I currently have the printf statement that shows that there are 2442 lines in your file1.txt and 217 lines in your file2.txt file.
Code:
awk '
FNR == NR {
# Save a line from the 1st input file...
col1_f1[++f1c] = $1
col2_f1[f1c] = $2
next
}
{ # Save a line from the 2nd input file...
col1_f2[++f2c] = $1
col2_f2[f2c] = $2
}
END { # Do whatever processing you want to do with the f1c lines you have
# read into col1_f1[] and col2_f1[] and with the f2c lines you have
# read into col1_f2[] and col2_f2[].
# ... ... ...
printf("%d lines in 1st input file, %d lines in 2nd file.\n", f1c, f2c)
}' file1.txt file2.txt
Hi ! all I am just trying to check range in my datafile
pls tell me why its resulting wrong
admin@IEEE:~/Desktop$ cat test.txt
0 28.4
5 28.4
10 28.4
15 28.5
20 28.5
25 28.6
30 28.6
35 28.7
40 28.7
45 28.7
50 28.8
55 28.8
60 28.8
65 28.1... (2 Replies)
Dear All
The following is part of my script:
echo ${myarray}
mytitle=`awk '{print substr(${myarray}, 0, length(${myarray})-4)}' /dev/null`
the echo ${myarray} works fine;
however, I keep getting following error for the mytitle=.. part:
awk: line 1: syntax error at or near {
awk: line... (3 Replies)
Please see below mentioned my script ... it ran once without any issue .... then after it is not coming out .... please suggest what is wrong?
#!/bin/ksh
## if (( ${num_errors} > 0 ));
export ACULOG=/home/varshnes/input
export num_errors=10
**** Search for 'Start correcting roll up... (7 Replies)
Hello all,
so this is a script i did for an assignement,
- first option greets the user according to the time after fetching his name
- second options isn't implemented
- third check the performance according to how many users are using the system
- creates a log of names, time and ip of the... (14 Replies)
Hi
I've made a short script but it is not working. Can some pl. help me out in this?
./123.sh
#! /usr/bin/ksh
# for changing to this directory
cd /layered/relational/scripts
When I run the above scripts, it doesn't change to the above directory. I don't what is the problem? the... (2 Replies)
Hi,
I have this example script which gives error ": unexpected operator/operand". I need the '' brackets for operator precedence.
#!/bin/ksh
x="abc"
y="xyz"
z="123"
if -a
then
print "yes"
else
print "no"
fi
Thanks (2 Replies)
I am trying to create a script but it is giving me errors on Cygwin for the following script. Could someone tell me, what am I doing wrong?
choice=1000
echo "choice is $choice"
while ; do
echo "choice is $choice"
echo 'Please select your option:'
echo '1. Option 1'
echo '2. Option 2'... (3 Replies)
I keep getting errors messages for the "else" statement at line 81?
#!/bin/ksh
######### Environment Setup #########
PATH=/gers/nurev/menu/pub/sbin:/gers/nurev/menu/pub/bin:/gers/nurev/menu/pub/mac
:/gers/nurev/menu/adm/sbin:/gers/nurev/menu/adm/bin:/gers/nurev/menu/adm/mac:/ge... (8 Replies)
Hey guys, can someone help me with this script...
#!/bin/sh
dir=`pwd`
for i in *.f
do if
then M=`wc -l < ${i}
sed -e 's://.*::' < ${i} | \
(echo "//${i} -"$M ; cat - ) > $i.tmp
chmod 700 $i ; mv ${i}.tmp $i
... (6 Replies)
02-09-2013
Logic I want to use in awk script
