Search Results

try this (copy in file and run)



awk '
NR==FNR&&NF>1{
x=$1;
for(i=2;i<NF;i++)
{
x=substr(x,1)":"substr($i,1);
};
a[x]=$NF
}
(NR!=FNR&&NF>1){
x=$1;...

In the same order as it appears in the inputfile:

perl -lne 'chomp; if(!defined $x{$_}){$x{$_}=1;print}' inputfile

sort -u filename.txt

awk '!a[$0]++' input.txt

one more in awk.

$ awk '!($0 in a) {a[$0];print}' infile

The way I understand what was desired, the text in the last field ("Approved", "Discontinued", "Phase II", etc.) should appear in the output files rather than putting "Approved" in that spot no...

The output produced by the script I supplied in message #3 in this thread is:
AST3 it is used in diabetes
GSTY4 it is used in diabetes
JST3 it is never applied in oedema
The output you said you...

If you don't mind getting rid of all of the whitespace between the 1st and 2nd fields in your second file when writing the output:
awk 'FNR==NR {wanted[NR] = $1; next}
{ nf=split($1, f1, ",")...

please provide the data for which output is not coming correctly

---------- Post updated at 10:18 AM ---------- Previous update was at 10:13 AM ----------

Also try this i made silly mistake in...

awk '{gsub(/\t/,"_")}1' file
Or
tr '\t' '_' < file
Or
sed 'y/[Tab]/_/' file

Use the Tab key in place of [Tab].

Hi,

Try this one,

awk 'FNR==NR{a[$1]=$2;next;}{if($1 ~ /,/){split($1,b,",");for(i in b){if(a[i]){print i,$2,$3,a[i];}}}else{if(a[$1]){print $0,a[$1];}}}' file2 file1

Again i assuming...

Yep as i thought, it's tab delimited :)