Putting "," after every item, except the last one

[lhg1]

Hi

I'm using this to get the destinct numbers in a list. this is a list from a logfile that I have to use in a SQL, so I have to put a , after every entery except the last one.

cat logfil.log|awk -F ";" '{print $1}'|grep -v QA |grep -v BAN|awk -F- '{++a[$1]}END{for(i in a)print i,a}'|awk '{print $1}'


It is easy to put it after every item '{print $1 ","}'
But I can't have it after the last one or the SQL will not work.

Does anyboddy have any ideers?

/Lhg

 

[PHV]

Brute force method:
... | awk '{print $1 ","}' | sed 's/,$//'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[columb]

Something along the lines of

...|awk -F- 'NR == 1 { printf $1 } {printf "," $1}'

On the internet no one knows you're a dog

Columb Healy

 

[PHV]

what about this ?
awk -F';' '$1!~/(QA|BAN)/{print $1}' logfil.log | awk -F- '{++a[$1]}END{c="";for(i in a){print c i;c=","}'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[columb]

Of course, it's a piece of cake in perl

perl -e 'my @bits; # Array to store output
while (<>)
  {
  my $short = +(split /;/)[0]; #Take only the bit before the ';'
  $short =~ /QA|BAN/ and next; #Reject lines with QA or BAN
  push @bits, +(split /-/, $short); #Add the first bit up to the '-' to the array
  }
#Print the array joined by commas
print (join (",", @bits));' logfil.log

On the internet no one knows you're a dog

Columb Healy

 

[PHV]

Sorry for the typo:
awk -F';' '$1!~/(QA|BAN)/{print $1}' logfil.log | awk -F- '{++a[$1]}END{c="";for(i in a){print c i;c=","}}'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[stefanwagner]

If you use dummy-columns ('dummy') and dummy-where-conditions (1=1) you may easily add more columns (even zero) and conditions (even none).

select 'dummy'
( , nr)
( , datum)
( , stand)
from foo 
where 1=1
(and nr > 7)
(and datum=today)
(and stand >= 5000);

How to apply to your case is left as an excercise to the reader.

don't visit my homepage:

http://home.arcor.de/hirnstrom/bewerbung

 

[Chapter11]

(stdin consisting of a list of numbers) | xargs echo | tr " " ",

 

[melone]

Could you do it in 2 steps?

Step 1, put comma after every item.
Step 2, delete the last comma.