topic Re: Awk Help in Operating System - HP-UX

Awk Help

Ash_4 — Tue, 28 Jan 2003 19:02:21 GMT

Hi Masters,
I am having file containing numbers
23654
234444
23444

I want the output like below,
insert '23654'
insert '234444'
insert '23444'

In short, how can i print ' in awk.
Thanks in adv

Re: Awk Help

John Meissner — Tue, 28 Jan 2003 19:03:40 GMT

cat file | awk '{print "'"$1"'"}'

Re: Awk Help

harry d brown jr — Tue, 28 Jan 2003 19:12:41 GMT

John,

you mean:

cat file | awk '{print "insert '"$1"'"}'

or faster:

sed "s/.*/insert \'&1\'/" < filename

live free or die
harry

Re: Awk Help

Leif Halvarsson_2 — Tue, 28 Jan 2003 19:20:16 GMT

Hi,
Or with shell script:

while read a
do
echo "insert '"$a"'"
done

Re: Awk Help

John Meissner — Tue, 28 Jan 2003 19:23:22 GMT

Harry - yeah... i guess... i didn't realize that they wanted the "insert" in the statement as well.

Re: Awk Help

Tom Jackson — Tue, 28 Jan 2003 19:24:21 GMT

Hi:

This works:

awk ' { printf "\x027insert\x027%s\n",$0 } ' inputfilename

Tom

Re: Awk Help

H.Merijn Brand (procura — Wed, 29 Jan 2003 09:26:12 GMT

Harry's sed problem is best, though it does not need the escapes for the quotes, nor does it need the redirection:

l1:/tmp 102 > cat > xx
23654
234444
23444
l1:/tmp 103 > sed "s/.*/insert '&1'/" xx
insert '236541'
insert '2344441'
insert '234441'
l1:/tmp 104 >

Re: Awk Help

Carlos Fernandez Riera — Wed, 29 Jan 2003 11:10:52 GMT

Oh Oh!
it should be :
sed "s/.*/insert \'&\'/"

because &1 append a '1' on each line.

Re: Awk Help

harry d brown jr — Wed, 29 Jan 2003 12:14:56 GMT

John,

I'm not sure the author will reply back.

Carlos,
You're right, I mangled the sed, here's one that works (and I took Procura's advice and removed the escaping of the apost's):

sed "s/$.*$/insert '\1'/" filename

live free or die
harry

Re: Awk Help

Ash_4 — Thu, 30 Jan 2003 03:37:07 GMT

Hi,
Extremly sorry for delay.
If have two field like below
293874 239487
239478 239487
----------
i want output as using "SED" or AWK
'293874' , '239487'
'239478' , '239487'

Re: Awk Help

Christian Gebhardt — Thu, 30 Jan 2003 06:24:21 GMT

Hi

echo "this is the trick" | awk '{printf("'\''%s'\''\n",$0)}'

in your case:
# cat inputfile
293874 239487
239478 239487
# awk '{printf("'\''%s'\'','\''%s'\''\n",$1,$2)}' inputfile
'293874','239487'
'239478','239487'

very clear, isn't it? ;-)

Chris

Re: Awk Help

Christian Gebhardt — Thu, 30 Jan 2003 06:28:19 GMT

uuups, with my browser i cannot read the quotes exactly, please try copy and paste and you will see:
quote-backslash-quote-quote to print ' in awk

Chris

Re: Awk Help

H.Merijn Brand (procura — Thu, 30 Jan 2003 08:31:25 GMT

Why not perl? Does it have to be sed or awk? Perl is so much fun!

Here's some obfuscated examples:

l1:/tmp 121 > cat file
12345
23456 78901
34567 89012 62534
45678 90123 72635 91827
l1:/tmp 122 > perl -ple '$"=",";$_=qq{@{[map{qq{\x27$_\x27}}split/\D+/]}}' file
'12345'
'23456','78901'
'34567','89012','62534'
'45678','90123','72635','91827'
l1:/tmp 123 > perl -nle 'print+v39,join(v39.44.39,split/\D+/),v39' file
'12345'
'23456','78901'
'34567','89012','62534'
'45678','90123','72635','91827'
l1:/tmp 124 >

Enjoy, have FUN! H.Merijn

Re: Awk Help

harry d brown jr — Thu, 30 Jan 2003 14:54:06 GMT

sed -e "s/$/ /" -e "s/$[0-9]*$[[:space:]]/'\1',/g" -e "s/'',//g" -e "s/',$/'/" filename

Works like this:

(1) The first "-e"

-e "s/$/ /"

Appends a space to the end of the line (so the next test will always work - hacking)

(2) the second "-e"
-e "s/$[0-9]*$[[:space:]]/'\1',/g"

Says match all number groups (numbers seperated by spaces, then wrap them with apost's and a comma)

(3) the third "-e"

-e "s/'',//g"

removes any BOGUS '', stuff

(4) the forth "-e"

-e "s/',$/'/"

Removes other BOGUS ', at the end of the line

live free or die
harry