Search Results

thanks a lot for the awk solution, just curious this cant be accomplished using a simple grep syntax with options ?

If I have a file like the following

abc.1
abc
abc_1
abc..1
abc*1
abc@1
abc def ghr
def......
ddef 5466 def ed
def** 123445



I`m trying to find exact words from the list

abc
def

please help with the following.

I have 4 col data .. instrument , category, variable and value. the instruments belong to particular categories and they all measure some variables (var1 and var2...

hello gurus,

I want to use an associative array from a file to populate a field of another file, by matching several columns in order of priority. If the first column matches, then i dont want to...

If two strings are same frequency,then any one can be 1 and the other -1.

I dont want to consider any other values than duplets AA,TT,GG ,CC ..For values like AT, - they should all be converted...

I would like to convert the most frequent and second most frequent duplet in each row to 1 and -1 respectively ...and everything else to 0. please assist

A duplet is only AA , CC, GG and TT

...

those columns are present as different names in different files..that is the confusion...thank you, I will try to work with the solution provided.

Sorry about the confusion.

Round 2

The keys are rid with ttable (tin or col1) , and fid with ftable (fin or col1) ...the issue is we have to detect which columns rid and tid are in the data...

I want to lookup values from two different tables based on common columns and append. The trick is the column to be looked up is not fixed and varies , so it has to be detected from the header. How...

Many thanks, and sorry about the missing comma.. Your code works great with the example files. My actual file names do not have pattern like "File number N", can I just point to the directory and...

Hello experts, I want to join a file with files whosE names are mentioned in one of the columns of the same file.
File 1

t1,a,b,file number 1
t1,a,c,file number 1
t2,c,d,file number 2...

Thanks a lot to both of you,, I`m getting different answers for your scripts,, does the data need to be sorted for any or both?

Update

It was the \r that was messing it up....thanks a lot...

Hi Experts,

Please help with the following.

I have 3 columns in File 1 , variables with values nested within groups.

File 1

gr1 var1 a
gr1 var2 b
gr1 var3 a
gr1 var4 c
gr2 var1 a
gr2...

Hello gurus, quick question

I have a bunch of folders each having subfolders that have 3 files with the same name but different in content. So I want to copy the subfolders with only those 3...

The code you showed us in your 1st post in this thread skips data in the 1st line of your file (which I assumed was intended to skip over a header line). But, I don't see any headers in this sample....

sorry about not providing with a sample input, I`m using cygwin. The data range is 0 to 100,000 should be outputted upto 2 decimal places.
Data is 83000 lines, not very big.

Yes, the code...

Wouldn't that add all the elements in the same row? I need average for each of the columns separately.

Hi experts,

I want to group by average, for multiple columns starting column $7 until NF,
group by ($1-$5), please help

For just 7th column, I can do

awk '
NR>1{
...

Hi senhia83,

thank you, your script may be problematic since the file is being read twice into memory..

Hi Scrutinizer, will your script work on unsorted data? My file is 23Gb and when I try to...

thanks, very helpful explanation ! .. I was wondering if there is a shortcut to reverse matching the 'geno' values without using specific sed arguments..like converting all generic xy$ and yx$ values...

hello masters ,

please help here. I have 4 cols, I am looking for consistent 'geno' values within
'line', 'part' combinations. If the geno values are not consistent within a 'line', 'part' block,...

thank you for a detailed explanation, ( fortunately ) i had compiled the dataset from 42 files...so I can run the awk filtering in a loop? I am sorting the datasets as you mentioned..the first col...

Hi all,

Please help with the following example.

I want to keep all people in the data, who at least have Firstname or Lastname or both and at least 1 row of Details. So, Person4 lacking both...

f <= nf {l[f, $1] = $2 # Checking condition here where variable f is less than and equal to variable nf's value, making array named l whose...

Don, would you please explain your code.. I plan to build on this in near future. thank you :)