Very Computer

hi,

Using the following line in my awk program doesn't yield the single
quote i am looking for in my output:

 printf("delete from  bin_inv where (serial_nbr = RTRIM('%s'))

i also tried
 printf("delete from  bin_inv where (serial_nbr = RTRIM(\'%s\'))

but that complains bout the printf statement syntax.

I am using a HP box in these examples.

Thanks in advance..

Quote:> hi,
> Using the following line in my awk program doesn't yield the single
> quote i am looking for in my output:
>  printf("delete from  bin_inv where (serial_nbr = RTRIM('%s'))
> i also tried
>  printf("delete from  bin_inv where (serial_nbr = RTRIM(\'%s\'))
> but that complains bout the printf statement syntax.

---
"... What with you being his parents and all, I think that you could
be trusted not to shaft him."  -- Robert Chang, rec.games.board

    b> hi,
    b> Using the following line in my awk program doesn't yield the single
    b> quote i am looking for in my output:

    b>  printf("delete from  bin_inv where (serial_nbr = RTRIM('%s'))

You seem to be missing four things from this statement:
  a) Closing quote
  b) String to sub into %s
  c) Closing paren for the printf
  d) Following semicolon

Eg:
printf("delete from bin_inv where (serial_nbr = RTRIM('%s'))", foo);

Where foo is an initialized string

[...]

Cheers,
Kevin

--
He that breaks a thing to find out what it is has left the path of
wisdom                                         -- Gandalf the Grey

--
Dan Mercer

Quote:

> Eg:
> printf("delete from bin_inv where (serial_nbr = RTRIM('%s'))", foo);

> Where foo is an initialized string

> [...]

> Cheers,
> Kevin

[...]

    DM> Semicolons are only necessary when you want more than one
    DM> statement on a line.  Printf statements do not take parentheses -
    DM> you can use them,  but they are treated as any other parenthetical
    DM> statement.  They can mask problems.  Awk isn't 'C'.

<remove foot from mouth>
Hmm...next time I should read all the words.  I missed the 'awk' part.
<replace foot in mouth>

[...]

Cheers,
Kevin

--
He that breaks a thing to find out what it is has left the path of
wisdom                                         -- Gandalf the Grey

Quote:>> You seem to be missing four things from this statement:
>>   a) Closing quote
>>   b) String to sub into %s
>>   c) Closing paren for the printf
>>   d) Following semicolon

>Semicolons are only necessary when you want more than one
>statement on a line.  Printf statements do not take parentheses -
>you can use them,  but they are treated as any other parenthetical
>statement.  They can mask problems.  Awk isn't 'C'.

The problem is that w/o the parens, the following is ambiguous:

        printf "%d",$1 > $2

For this reason, I got in the habit of always using parens with printf.