Search Results

Hi all,

I have a file in which each string from column 1 is associated with one or multiple strings from column 2. For an example, in the sample input below, Gene1 from column1 is associated with...

HI guys,

I could write a write a script which does the task but the problem is, it works only on the files which are present in the current directory. I need it to be working on subdirectories as...

Hi all,

I have more than 12000 files in 46 different directories and each directory has 2 sub-directories named “dat” or “gridded”. Dat sub-directories have files...

When I tried your script it printed 0s and 1s instead of column 3 values. Anyway I followed your suggestion to use R and it worked fine for me. Thanks.

I am taking an example data set here:

a a 1
a b 2
a c 4
b a 2
b b 1
b c 7
c a 4
c b 7
c ...

Hi all,

I have a 3 columns input file like this:

CPLX9PC-4943 CPLX9PC-4943 1
CPLX9PC-4943 CpxID123 0
CPLX9PC-4943 CpxID126 0
CPLX9PC-4943 CPLX9PC-5763 0.5...

Thanks Guys. pravin27s perl script runs fine too. I could see some problem with RudiC's scipt though. Thanks once again. :b:

Thanks bipinajith. It just that its printing non_match files for those combinations also where there is no match.

Also, Could you please help me in making files having combination pairs of...

Hi all,

I have two files, chap.txt and complex.txt.

chap.txt looks like this:

a
d
l
m
r
k


complex.txt looks like this:

a c d e l m n j
a d l p q r
c p r m
.........

Cragun, your script is working fine and gives the desired results. Thank you very much.

Thanks for the help but, although it successfully removes the duplicates in column 1, it does not print last (value) column along.

Hi all,

I have a list of node pairs separated with a comma and also, associated with their respective values. For example:

b0015,b1224 1.1
b0015,b2576 1.4
b0015,b3162 2.5...

Thanks Corona688 for the reply. Files containing CYTOCHROME C are treating your script very well. Above I took examples of those files which are throwing errors. The only difference here is, I am...

Thank you very much Corona688, you made my day :).
This script is working fine when I put it in a shell script like this:

cat temp.sh
awk -F":" '(!RGX) && /CYTOCHROME C/ && (NF==2) {
...

I have hundreds of files to process. In each file


I need to look for a pattern then
extract value(s) from next line and then
search for value(s) selected from point (2) in the same...

Dear all,

I need to search multiple patterns and then I need to print their respective next lines. For an example, in the below table, I will look for 3 different patterns :

1) # ATC_Codes:
2)...

Thank you guys. I got my results.
@vbe - Thanks for the reminder. I will keep it in mind next time.

Hi all,

I have 2 files. One contains only 1 column and other one contains 2 columns, let say 1_col.txt and 2_col.txt respectively. Here, I will try to explain with an example.

Input files :
...

Gurus,

I have a file containing lines like this :


Now, number of words in each line varies. My need is, if a word repeats in a line get it printed. Also total number of repeats.

So, the...

ranjithpr and rdcwayx, thanks to both of you. Its running very fast and fine. I am wondering if you could spare few minutes and explain me the logic. Once again, many many thanks for saving my day.

Hi,
I have two files. 1st file has 1 column (huge file containing ~19200000 lines) and 2nd file has 2 columns (small file containing ~6000 lines).
#################################
huge_file.txt...

Guys, I am still in a real fix. All I want is to extract column from excel files as it is.
If there are blanks in the column, they should be in the output.:confused:

@Franklin52 :
Sorry for being such a pain here but I really don't know how to do that for more than 1000 files.
I am using Fedora 8.

I simply created a artificial ".txt" file with same content what I have given in my 1st post. your script is working very fine on it. But when I convert ".xls" file into ".txt "or ".csv" file, its...

Franklin52


thanks guys for quick replies.
@Franklin52 : yeah, all Input files are excel files. Its (script provided by you) working fine with " .txt " file but not with excel file, I afraid.
...