Parsing NTE subfield

Clovertech Forums Read Only Archives Cloverleaf Cloverleaf Parsing NTE subfield

  • Creator
    Topic
  • #54115
    tyler tesson
    Participant

      I am attempting to strip out the operator employee number in an NTE field. Here is how we receive it:

      NTE|||Operator: 010101111 Lname  Fname

      Need it to look like:

      NTE|||Operator: Lname  Fname

      The main issue is the number is not a fixed length, but it will always start as Operator:

      I have been attempting this in a tcl, but haven’t had much luck yet. Is the best way to key in on the : and look for the next space after the number?

      Thanks for the help

    Viewing 0 reply threads
    • Author
      Replies
      • #80215
        Jim Kosloskey
        Participant

          Try the split command using space as the delimiter. This will produce a list with all of the elements you see, the second element then is the ID. you can then just delete the second element (lreplace) then rejoin the list into a variable.

          email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

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