I have an SMS Gateway integrated with Adobe Campaign. The problem is it can only send SMS messages with the country code in front of the number, but most of our customer data does not contain the country code. We are in Australia (Country code +61) but mobile numbers start in 04. Thus, most of the mobile numbers in our database are stored as "04xx xxx xxx" when they need to be "614xx xxx xxx". Is there any way in a workflow or the data loading/update data function to change all entries that start with 04 to start with 614?
There isn't an explicit 'prefix' field corresponding to the phone number which could allow you to update the prefix from 0 to 61 within a Workflow Activity.
You might have to change the phone numbers completely and that would be too inefficient since the query will have all the possible phone numbers (starting with 0) to be replaced with phone numbers starting with 61.
However you could consider the TON and NPI Settings in case the SMS Connection is being established with vendor through Extended Generic SMPP, see below Screen Shot:
NPI (Numbering Plan Identification) and TON (Type of Number) combination might allow the phone number prefix to be 0 on your side and 61 on vendor's side. For '0', TON value would be '2' (National) and for '61', TON value would be '1' (International).
The NPI value becomes '1' (ISDN/telephone numbering plan) for numbers starting with '61' and '8' for numbers starting with '0'.
Considering you are on v7, I am assuming that you might be using Extended Generic SMPP Connector only.
If so, then you could try this combination once.
For reference, below are the standard NPI and TON values: