Please try out this :
Code :
Basically first redirecting the *.txt s and *.beds in 2 different files and taking out the values before *.txt s in 3rd file removing *.txt from each line.
Later making 3rd file as the primary file and comparing its each line (using for loop) with each line of 2nd files values i.e *.beds(using for loop),by line starting with primary file's each lines .
Once the criteria meet, check the exit status is 0 then go for checking the 2nd condition "$10>30 && $11>49" and if both are met then display primary file's each lines else mention "No Match found".At last removing the temporary files created.
Thanks,
Sanghamitra
Hello Sanghamitra C.,
Welcome to forums, hope you will enjoy learning/shraing knowledge here. Not sure if you have tested above code or not. There could be few points which we could to make above code better.
i- echo "$j" | grep "^$i", could be changed to if [[ "$j" == "$j" ]]. Because we need to check either file names are equal or not.
ii- if[ "$10" > "30" && "$11" > "49" ], for this code in shell $10 or $11 fields are not considered like that, they work in this format in awk. You could use cutto take the 10th and 11th field's values.
iii-for i in `cat /mydir/file2` and for j in `cat /mydir/file3`codes could be done by whileloops for an example.
Thanks,
R. Singh
These 2 Users Gave Thanks to RavinderSingh13 For This Post:
Hey,
I'm very new to AWK and am trying to write a script that counts the number of files in all subdirectories. So, basically, my root has many subdirectories, and each subdirectory has many files.
How can I get the total count? I haven't been able to figure out how to loop through the... (1 Reply)
Hi All,
I am using the awk command to replace ',' by '\t' (tabs) in a csv file. I would like to apply this to all .csv files in a directory and create .txt files with the tabs.
How would I do this in a script?
I have the following script called "csvtabs":
awk 'BEGIN {
FS... (4 Replies)
Hi Guys,
Can you tell me if unix permissions apply to sub dirs?
Dir is /home/ops/batch/files/all
/home is rwxrwxrwx
ops is rwxrwxrwx
batch is rwxr-wr-w
files is rwxrwxrwx
all is rwxrwxrwx
Having problems writing to all (does the userid nee to be the batch owner... (1 Reply)
Hi,
I have a bunch of records within a directory where each one has this form:
(example file1)
1 2 50 90 80 90 43512 98 0909 79869 -9 7878 33222 8787 9090 89898 7878 8989 7878 6767 89 89 78676 9898 000 7878 5656 5454 5454
and i want for all of these files to be... (3 Replies)
HI there. My teacher asked us to write a code for this question
Write a Unix shell script named 'mode' that accepts two or more arguments, a file mode, a command and an optional list of parameters and performs the given command with the optional parameters on all files with that given mode. ... (1 Reply)
Write a Unix shell script named 'mode' that accepts two or more arguments, a file mode, a command and an optional list of parameters and performs the given command with the optional parameters on all files with that given mode.
For example, mode 644 ls -l should perform the command ls -l on all... (5 Replies)
Hi,
My script works fine when I have both input files in the same directory but when I put on of the input file in another directory, the output does not show up.
SCRIPT:
awk '
BEGIN {
OFS="\t"
out = "File3.txt"}
NR==FNR && NF {a=$0; next}
function print_77_99() {
if... (3 Replies)
Greetings Experts,
I am on AIX and in process of creating a re-startable script that connects to Oracle and executes the statements. The sample contents of the file1 is
CREATE OR REPLACE VIEW DB_V.TAB1 AS SELECT * FROM DB_T.TAB1;
....
CREATE OR REPLACE VIEW DB_V.TAB10 AS SELECT * FROM... (9 Replies)
I am trying to look for $2 of file1 (skipping the header) in $2 of file2 (skipping the header) and if they match and the value in $10 is > 30 and $11 is > 49, then print the line from file1 to a output file. If no match is foung the line is not printed. Both the input and output are tab-delimited.... (3 Replies)
In the awk below I am trying to use the file1 as a match to file2. In file2 the contents of $5,&6,and $7 (always tab-delimited) and are copied to the output under the header Quality metrics. The below executes but the output is empty. I have added comments to help and show my thinking. Thank you... (0 Replies)