Search Results

Thank you very much MadeInGermany. thanks for figuring out my error. its a great help :)

sorry DGPickett, I tried such a way also but as sometimes I have to match with 2nd col (see the last example) also, it getts messed :(

Dear zaxxon,
Thank you very much. But it still producec the similar output which I already got.
But I have the file bit more complicated. I am editing your example. Thanks for creating the...

Dear zaxxon,
that is I tried to explain for example in first file:
1000094 2
10039307 1
10039641 1
10047177 11
10047359 1

format is ist col:ID, 2nd col:count

Now I need to search each...

Sorry Zaxxon,
I don't understand what you mean. My file one do not have a heading.
But fist col is ID and second col is count

Now I want to match this ID from either 1st or 2nd col of File 2...

thanks krishmaths,
yes I did that. But what I ment to say is, I don't have "-" in any other col for the first file. but in another I had. Thus I realized that must be the problem while other codes...

Thanks krishmaths,
Yes I guess that is the case. As first two commands deliver the file with size >300MB
But other just over 200MB.

No I am not sure..in some cases files may have - in other...

Dear Shell experts,
I have 2 files with structure:
File 1: ID and count
head test_GI_count1.txt
1000094 2
10039307 1
10039641 1
10047177 11
10047359 1
1008555 2
10120302 1
10120672 13...

Thanks a lot all for your help. It worked perfectly with krishmath and vidyadhar85's suggestions...
Just Ice, thanks to you also, but as I have "-" in 3rd Gene symbol col also sometimes, thus I...

Hi,
my file structur looks like
File structure looks:
GeneID protein_gi Symbol
1246500 10954455 repA1
1246501 10954457 repA2
1246502 10954458 leuA


But some of the cases do not have...

smitra:TRFLP-RawData smitra$ head -5 TRF_raw_data_reactor1.csv | cut -c 1-100
Sample Name,Marker,RE,Dye,Allele 1,Size 1,Height 1,Peak Area 1,Data Point 1,Allele 2,Size 2,Height 2...

Hello bartus11,
I am trying this...
smitra:TRFLP-RawData smitra$ awk 'NR==1{for (i=1;i<=NF;i++) if ($i~"^Peak.Area") {printf $i" ";a[i+1]=1};printf "\n"}
NR>1{printf $1" ";for (i=2;i<=NF;i++) if...

My Data is e.g.:
Sample.Name Marker RE Dye Allele.1 Size.1 Height.1 Peak.Area.1 Data.Point.1 Allele.2 Size.2 Height.2 Peak.Area.2 Data.Point.2
1 D71I1A ...

Hello Unix experts,
I need a help to create a subset file. I know with cut comand, its very easy to select many different columns, or threshold. But here I have a bit problem as in my data file is...

Hi Pamu,
Thank for the reply. I tried to put space in the square bracket. But still the same problem And I am not sure how to fix the loop. :confused:

osch=0
echo "1. Delete row from file"...

this is the output so far...

1. Delete row from file
2. Delete columns from file
Select your choice [1 or 2]?
1
./test-array: line 14: syntax error near unexpected token `do'
./test-array:...

Hi group,
I am very beginner in shell scripting and self learning.
I am trying to create and executable script to run awk from user defined variables.

e.g. suppose from a given file I want...

Hi Pamu, Elixir_sinari,and Alister,
Thanks for your reply. Actually I was trying to set it as array like
echo "Enter col numbers with space"
read x
echo 'You entered this line:...

Hello,
suppose I have something like:

1 1 5 1 1 5 1 1 5
1 1 1 1 1 1 1 1 1
1 4 1 1 4 1 1 4 1
1 1 3 1 1 3 1 1 3
1 5 1 1 5 1 1 5 1
4 1 1 4 1 1 4 1 1
1 1 4 1 1 4 1 1 4
5 3 5 5 3 5 5 3 5...

Thanks Pamu,
But where should I put the colum number to delete?

Hi group,
Can you please tell how to delete specific columns from a file.

I know something like
awk -F, '{ print $1" "$2" "15 }' input.txt > output.txt will delete all other columns. But...

Hello,
I tried to use

./plink --noweb --fam myfile.fam --bim myfile.bim --make-bed --out myfile.bed

But still didn't work. Here is the error message below. Can anybody PLEASE HELP?
...

Hello Corona688,
Thanks for your reply. But I also have seen this. But this is Given test.ped and test.map, but I have only bim and fam and I want to create bed file. Given .ped and .map, program...

Thanks Corona688,
My file format is like:
Sample Name SNP Name Sample ID Allele1 - Top Allele2 - Top GC Score Allele1 - Forward Allele2 - Forward Allele1 - Design Allele2 - Design Allele1 -...

Hi Plink users,
I am very new in GWAS and decided to use PLINK for this. But I am struggling with file formats.
I have one exome data with 200000 SNPs in it. But it is in .txt format. But all the...