csv data

Viewing 2 reply threads
  • Author
    Replies
    • #74949
      Jim Kosloskey
      Participant

        Dave,

        You could do it in a pre Xlate proc using something like string map or regsub to get rid of all ” prior to Xlating or in a post xlate UPoC (like post xlate or outbound) to get rid of the ” after xlate.

        Or… use tcl for each field that you want the ” removed.

        I have not found any other way to remove those simply by configuration (like the outbound VRL does not have the surrounding escape characters set and the inbound does so none are copied).

        However, make sure the inbound fields will NEVER have field separtors imbedded (that is what the ” are supposed to protect agains) and that the receiving system can handle unescaped fields with imbedded field separators or this won’t work.

        email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

      • #74950
        David Harrison
        Participant

          Jim,

          That’s confirmed what I thought.

          Many thanks,

          Dave

        • #74951
          Charlie Bursell
          Participant

            Simplu use the csv package.  It will work for you

        Viewing 2 reply threads
        • The forum ‘Cloverleaf’ is closed to new topics and replies.