Parsing NTE subfield

[tyler tesson]

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

Topic

[Jim Kosloskey]

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.

[Author]

Replies