HP3000-L Archives

December 2000, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Tad Bochan <[log in to unmask]>
Reply To:
Date:
Thu, 14 Dec 2000 11:29:50 +0100
Content-Type:
text/plain
Parts/Attachments:
text/plain (111 lines)
>> Jeff Sohrt wrote : Can you give an example?

Hi Jeff,
My usage of quote() was simply to double up on quotes,
I have not delved into the other functionality alluded to
by Jeff, and I am quite happy to accept quote() as obsolete.

eg.,

anyparm  astring=ABC'PQR"XYZ
setvar qstring anyparm(!astring)
setvar qstring quote(qstring)
run prog;info="![qstring]"
==> RUN PROG;INFO="ABC''PQR""WYZ"

however,  this usage is flawed since it will
double up on both single *and* double quotes
and therefore using repl() is better since it
gives the desired result.

anyparm  astring=ABC'PQR"XYZ
setvar qstring anyparm(!astring)
setvar qstring repl(qstring,'"','""')
run prog;info="![qstring]"
==> RUN PROG;INFO="ABC'PQR""WYZ"

regards,
Tad.





Internet

From:     [log in to unmask] on 14/12/2000 01:35 GMT



Pour :    Tad BOCHAN

cc :

ccc:

Objet :   RE: Réf.[2]: Quote function ?




if you don't mind me asking, what's the context that you're using the REPL
function.  sounds like you wanted to double up quotes in a string, but what
Jeff Vance replied with was a completely different example.

I assume you're doing this for the purpose of some kind of SQL statement
that would require quotes around quotes????

Can you give an example?

jds

> -----Original Message-----
> From: Tad Bochan [mailto:[log in to unmask]]
> Sent: Wednesday, December 13, 2000 10:19 AM
> To: [log in to unmask]
> Subject: Réf.[2]: Quote function ?
>
>
> >>   I am happy to help you workaround the lack of quote().
>
> Hi Jeff,
>
> No problem, REPL() it just fine.
> I just thought QUOTE() was a bit more descriptive in the context
> of hacking quotes in strings.
>
> Thanks,
> Tad
>





___________________________________________________________

This message and any attachments (the "message") are intended solely for
the addressees and are confidential.  If you receive this message in error,
please delete it and immediately notify the sender.

Any use not in accord with its purpose, any dissemination or disclosure,
either whole or partial, is prohibited except formal approval.

The internet can not guarantee the integrity of this message.  BNP PARIBAS
(and its subsidiaries) shall (will) not therefore be liable for the message
if modified.
                       --------------------------------------------------
Ce message et toutes les pieces jointes (ci-apres le "message") sont
etablis a l'intention exclusive de ses destinataires et sint confidentiels.
Si vous recevez ce message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur.

Toute utilisation de ce message non conforme a sa destination, toute
diffusion ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse.

L'internet ne permettant pas d'assurer l'integrite de ce message, BNP
PARIBAS (et ses filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.
___________________________________________________________

ATOM RSS1 RSS2