Search Results

my command

nawk -F' ' '{for(i=1;i<=NF;i++){if ($i ~ /XX/) print i}}' TOM.bk


The output is in two lines as below

12
30

i want the output in one line with comma delimited
as below
...

ORS=,

but it continuous in one line,
output is

23,79,

and i want

23,79

i get syntax error.
my command prints the column numbers where it finds XX

my command

nawk -F' ' '{for(i=1;i<=NF;i++){if ($i ~ /XX/) print i}}' a.bk


The output is in two lines as below

23
79

i want the output in one line with comma delimited
as below
...

This work perfectly, thanks

my delimiter is no more comma, it is space

---------- Post updated at 08:32 AM ---------- Previous update was at 07:40 AM ----------

when i run

awk -F, -vOFS=" " '{a[$1]+=$2}END{for (i in a)...

HP-UX acccesm B.11.23 U ia64 3169354550 unlimited-user license

i have a file with two columns, and i want to uniquely sort the values in fist column and add the corresponding values in the second columns
eg
file a contents



tom 200
john 300
sow 500...

it worked, but i changed the delimiter to space and am finding it hard to work

file becomes


tom 200
john 300
sow 500
tom 800
james 50
sow 300

i have a file with two columns, and i want to uniquely sort the values in fist column and add the corresponding values in the second columns
eg
file a contents

tom,200
john,300
sow,500...

works perfect,thanks Kevintse

I have another file with three columns A,B,C as below


123,1,502
123,2,506
123,3,702
234,4,101
235,5,104
456,6,104
456,7,100

i want to sort such that i get a unique value in column A,...

it worked thanks

I have a file with contents below

123,502
123,506
123,702
234,101
235,104
456,104
456,100



i want to sort such that i get a unique value in column A, and for those with multiple...

when i use awk i get the output

123|zoo|tail|see
234|natan|pay|rat
456|don|som|sin

it should be

123|zoo|dog|pie
123|zoo|tail|see
234|natan|pay|rat
456|don|som|sin

i am unable to use nawk, i get some error

now i have a different file zoo.txt with content

123|zoo
234|natan
456|don


and file rick.txt with contents


123|dog|pie|pep
123|tail|see|newt
456|som|sin|sim
234|pay|rat|cat

...

output should be

tom | NOO
lasole|YES
jon|YES
gille|YES
sam|YES

its not working

i have a file a with contents


tom
lasole
jon
gillesam

and a file b with contents



tom|1234|abcf|newyork,ohio,oregon
sam|2345|drft|texas,london
hyle|4444|befr|wisconsin...

i have a file a with contents

tom
lasole
jon
gille
sam

and a file b with contents

tom|1234|abcf|newyork,ohio,oregon
sam|2345|drft|texas,london
hyle|4444|befr|wisconsin...

i have two files with contents
file a

1234,abcf
2345,drft
4444,befr


file b

tom,3
sam,5
dog,7


i want to print first column of file b and join to file a and get output as below
...

thank you, both worked

Hi,
i have a file with content

00:01:20.613 'integer32' 459254
00:01:34.158 459556
00:01:36.626 'integer32' 459255
and i want to print only output as below

00:01:20.613 459254...

Hi,
I have a file contaning some variables with negative values, but i just want to print the positive value
awk -F"|" '$2<0 { print $1,$2 }' tom.unl > tee.unl

i want the $2 = absolute value...