Re: [sqr-users] Fwd: Double double-quotes

["George Jansen" <GJANSEN@aflcio.org>]

If you're working with Oracle you might want to make life easier on
yourself and use PL/SQL or pure SQL. But if there's only ever one such
embedded string, then one cheap way would be to use unstring/string.
Maybe the Ontko gang have a cleaner way, though:


begin-program

  let $p1 = 'William Jefferson "Bill" Clinton'
  let $p2 = 'George "W" Bush'

  Do dq($p1, $p1a)
  Do dq($p2, $p2a)

  show $p1a
  show $p2a

end-program

Begin-Procedure dq ($instring, :$outstring)
  unstring $instring by '"' into $smokey $the $bear
  string $smokey $the $bear by '""' into $stb
  let $outstring = '"' || $stb || '"'


End-Procedure

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users