Hi all,
I have to bulk update a whole bunch of phone numbers.
The current format is ten digits, starting with a 0. I need to convert these numbers to area code + local number.
The area code is either three or four digits followed by a dash (-).
The area codes are stored in enclosed file "PhoneUpdating"
The input and output phone numbers are in "PhoneOutput"
What I'd like FME to do:
When the first three or four digits in the "Phone" column match with the thee or four digits found in AreaCode: then replace these with the data found in AreaCodeUpdated. (output examples in green)
Example files:
Thanks again,
Ed