Clovertech

Zero Suppression using Xlate

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › Zero Suppression using Xlate

  • Creator
    Topic
  • December 2, 2005 at 3:44 pm #48180
    Ken Seachrist
    Participant

      🙄  I have a simple Xlate that I am using, but now I need to zero suppress a field.  I really do NOT want to create a TCL proc just to do this for one field, if I don’t have to, so does anybody know if you can zero suppress a field in Xlate?

    • Creator
      Topic
    Viewing 1 reply thread
    • Author
      Replies
      • December 2, 2005 at 4:33 pm #57921
        Rentian Huang
        Participant

          Ken,

          Are you saying that you wanna replace all zeros? If that’s the case, I don’t think you can do this without any tcl.

          A simple CALL with 3 line of code will do this task thou.

          Code:

          set var [lindex $xlateInVals 0]
          set var [format “%f” $var]              ;# if suppressing leading zeros
          set var [string map “0 “”” $var]    ;# if suppressing all zeros
          xpmstore $xlateId [lindex $xlateOutList 0] c $var

          Hope this helps,

          Sam   🙂

        • December 2, 2005 at 6:54 pm #57922
          Anonymous
          Participant

            Ken,

            What is the record format of the source field?  If it’s FRL then you can specify “0” as the padding character and the engine will strip them when the field is parsed.

        • Author
          Replies
        Viewing 1 reply thread
        • The forum ‘Cloverleaf’ is closed to new topics and replies.