pulling a specific phone number

Kevin,

You want to iterate through the repetitions of the field, and for each one of them test whether it contains “CO”. If it does, then write the value out to the destination. If it doesn’t, don’t do anything. Go on to the next repetition.

As stated you could maybe do this in Xlate.  But if you want to do in Tcl

I’m a little confused as to what you want.  Do you want to simply move the number to the front or replace what is in front with the number?

Assume you want to simply move number to front.  Assume you have extracted the field to variable fld

set lst [split $fld $repSep]

set loc [lsearch -regexp $lst {CO$}]

if {$loc >= 0} [

    set CO [lvarpop lst $loc]

    set fld [concat $CO $lst]

}

set fld [join $fld $repSep]

If you want to replace first element with number then change

    set fld [concat $CO $lst]

to

    set fld [lreplace $lst 0 0 $CO]

Kevin,

This could be done in an Xlate as Chris indicated or in Tcl as Charlie indicated.

If you are using an Xlate you may need some Tcl. If you are on Cloverleaf 5.6 or later you won’t need Tcl to test for the CO (assuming it can only occur once in each iteration) as I think the new contains (ct) string oerand will do the trick.

However if you want to take some portion of the telephone number then you will probably need some tcl for that.

Of course if the provider of the message had followed the standard (I am assuming version 2.3 or later) then this XTN data type for Phone should have had all the pieces of the telephone number (including the identifier of type of phone – which I assume the CO is) in their proper components and then you would probably not need any Tcl in the Xlate.