Someone might find this useful.
Facebook custom audience uploads accepts mobile number as a data field, but it must be formatted with the international country code. Details: https://www.facebook.com/business/help/606443329504150
It's rare that a customer would include the country code when they enter their number online, and we don't enter it manually when taking orders over the phone.
Output set element to the rescue! This output set element will replace any mobile number with 04 at the front (for non-Australians, this is our mobile number prefix) with +614, meaning your data will be A-OK to be uploaded into Facebook when you run the output set.
Description: Phone - Mobile - Int formatCategory: ConstituentData select: case when LEFT(!.phone,2)='04' then stuff(!.phone,1,2,'+614') endData from: LVS_OTHER_PHONEData where: !.type=x (Note: check your TR_PHONE_TYPE and replace x with the correct type for your database
Enjoy
dgh