Processing numbers with extra characters

[Tom Arrowsmith]

I am working on an interface where I need to convert some phone number formats and social security format. In particular, the inbound phone #, (xxx) xxx-xxxx, needs to be converted to (xxx)xxx-xxxx, which is simply the dropping of the space after the three digit area code.

The social security number inbound is xxx-xx-xxxx and needs to be converted to xxxxxxxxx.

I’m guessing this will require a tcl script – but I would also welcome an xlate solution.

Thanks!

Tom

Topic

[Jim Kosloskey]

Tom,

You can do that with Tcl inside the Xlate.

I would suggest string map command.

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

[Tom Arrowsmith]

Thanks, Jim. I got your email and will take a look!

Tom

[Author]

Replies