Search Results

$ cat file
{
aaa
bbb
aaa
ccc
}
ads
dvsah
{
aaa
aaa
}


$ awk '/\{/ {f=NR} f && !A[f,$0]++ {print} !f{print} /\}/{f=0}' file
{
aaa
bbb
ccc

Not clear what exact you want.

Please give some more details about what you want.

$ awk '/AUS\.txt/{print "AUS.txt"}' file

AUS.txt

Then try my solution :)

Try

$ awk -F, 'BEGIN{print "record_number , columns_with_diff"}
NR==FNR{for(i=2;i<=NF;i++){A[$1,i]=$i}next}{for(i=2;i<=NF;i++){if($i!=A[$1,i]){p=p?p","i:i}}print $1,p;p=""}' file1 file2...

$ awk -F "[ \|]" 'NR==FNR{if($NF=="N"){A[$2]++}next}{if(!A[$NF]){print}}' file2 file1

$ egrep ",[0-9]{3}-[0-9]{2}-[0-9]{2},|,[0-9]{4}-[0-9]-[0-9]{2}," file

1345721,999-03-20,400
2678103,2010-4-10,500

Yes agreed, But many times we don't have many options.
I have only putty to access this DB and I want to validate there itself. You should understand that there are many things which are not in our...

Thanks for the quick answers.

but how we can do it for isql ?

How to Get SQL query result to file in putty?

I have one SQL query and I want that query output to be redirected to the file.

uname -a
SunOS XXX 5.8 Generic_117350-58 sun4u sparc...

$ sort file | awk 'BEGIN{print 0"\t"0;a=0.14}{ printf "%s\t%s\n", $1,a;a+=0.14}'

0 0
19.2 0.14
20.7 0.28
21 0.42
28.3 0.56
32.5 0.7
34.3 0.84
37.6 0.98

without gsub

awk -F "[: ]" 'NR==FNR{$0=toupper($0); A[$1]=$2;next} {$NF=A[$NF]}1' Mapping Config

OR

$ awk -F , '!$4{$4="BIKE"}1' OFS="," file

1,abc,55,CAR
3,bb,dd,CAR
5,ddd,tttt,BIKE
8,ee,55,BIKE

awk 'NR==FNR{$0=toupper($0);split($0,P,":");A[P[1]]=P[2];next} {gsub($NF,A[$NF])}1' Mapping Config

echo "isgc jsfh udgf osff 8462 error iwzr 653 idchisfb isfbisfb sihfjfeb isfhsi gcz eifh" | awk -F "error" '{split($2,P," ");print P[2],P[4],P[5],P[7]}'

653 isfbisfb sihfjfeb gcz

awk 'NR==FNR{B=$0;getline;A[B]=$0;next} {D=">"$0; print D;print A[D]}' file2 file1

>EN_comp12952_c0_seq3:367-1668
MDKRLLNVSLLGLAFMFVFTAFQTMGNIEKTILKSIQNDYPSFTGDGYTSL
>ES_comp17168_c1_seq6:1-864...

awk 'NR==FNR{A[$3]++;next}{if(A[$3] > 1 && !B[$3]){B[$3]++;next} }1' file file

12 NIL ABD LON
12 NIL ABC AMR
13 NIL ABC AMR
11 NIL ABK AMR

$ awk '/Sheep/{F=1} /Realized/{if(F){print "a goat"}else{F=""}} {print}' file
Cat
Realized
Dog
Realized
Sheep
s
d
f
jk
a goat
Realized
Wolf
a goat
Realized
Sheep
s
d
a goat
Realized

for creating new file/overriding data into fileecho "Hello World" > hai.txt

for appending data into fileecho "Hello World" >> hai.txt

tryawk -F "\t" '{A[$1]=A[$1]?A[$1] ", " $NF :$1 " "$NF}END{for (i in A)print A[i]}' file

modified your code
try
key="phani;ravi;kiran"
number_of_keys=$(echo $key|awk '{print NF}' FS=';')
for (( i = 1; i <= $number_of_keys; i++ ));
do
key=$(echo $KEY_TO_COMPARE|awk -v var=i 'BEGIN {...

try

$ cat file
Cvel_1 KOG0155
Cvel_1 KOG0306
Cvel_1 KOG3259
Cvel_1 KOG0931
Cvel_1 KOG3638
Cvel_1 KOG0956

$ awk '{A[$1]=A[$1]?A[$1] ", " $NF :$1 "...

grep -C1 Jak file

It will give above yes and below lines

Try

awk -F "|" '{A[$1]=A[$1]?A[$1]"|"$NF:$1"|"$NF;next}END{for(i in A) {print A[i]}}' file

try

sort -u -t "|" -k1,1 -k4,4 -k6,6 -k8,8 file

What you tried so far..?

Have you checked scp and rsync ...?