1. Forum
  2. Usenet
  3. COMP.LANG.MUMPS

  • SQL/Control characters

    From Steve@21:1/5 to All on Thu Jan 7 08:31:13 2021
    Need to remove control characters from the output of Cache SQL. Can that be done within SQL? Using $ZSTRIP? Something else?

    Steve

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Rod Dorman@21:1/5 to solitary.wanderer52@gmail.com on Thu Jan 7 18:53:59 2021
    In article <e6082b03-e59b-4942-939a-5593cd53e0c1n@googlegroups.com>,
    Steve <solitary.wanderer52@gmail.com> wrote:
    Need to remove control characters from the output of Cache SQL. Can that be >done within SQL? Using $ZSTRIP? Something else?

    $ZSTRIP(string,"*C") will remove all the control characters from string

    --
    -- Rod --
    rodd(at)polylogics(dot)com

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)