Clovertech

VRL subfield parse

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › VRL subfield parse

  • Creator
    Topic
  • June 6, 2012 at 4:03 pm #53129
    Bob Schmid
    Participant

      Value:

      ……,OREGON            OH 43616,….. 😕

      record defined as:

      Deaful Field sep – ,

      Default subfield sep -x20

      Fiefld min width 1

      max width -1

      subfields defined as:

      subfield1 –  min width 18, max width 18

      subfield2  – min width 2 , max 2

      subfield3 – min width 5, max 5

      running in tester…alllll we ever see is

      Guarantor_Addr2: ch

                          0: ch >OREGON<                     1: ch ><                     2: ch ><

    • Creator
      Topic
    Viewing 1 reply thread
    • Author
      Replies
      • June 6, 2012 at 4:29 pm #76671
        Bob Schmid
        Participant

          Verification warnings: with input validation on FRL parse

          Guarantor_Addr2.[1]: subfield is less than MIN

          Guarantor_Addr2.[2]: subfield is less than MIN

        • June 6, 2012 at 8:09 pm #76672
          James Cobane
          Participant

            You may need to treat it as a single field (not use the space as a sub-field separator) and do some tcl code on it; i.e.

            set CityStateZip [regsub -all {s+} [lindex $xlateInVals 0] ” “]

            This would then return: OREGON OH 43616

            as it is replacing any one (or more) spaces with a single space.

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