Changing incoming data in Data Loading/Update Data Function?

Avatar

Avatar

alb52547777

Avatar

alb52547777

alb52547777

26-08-2018

Hi all,

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?

This is Adobe Campaign Classic v7

Many thanks,

Alex

View Entire Topic

Avatar

Avatar

preethamk581070

Avatar

preethamk581070

preethamk581070

24-09-2018

Hi alb52547777​,

Alternatively, you can modify the data in transition using SQL activity like this,

UPDATE <%= vars.tableName %> SET semail = RIGHT(semail, '10');

UPDATE <%= vars.tableName %> SET semail = concat('61', semail) where length(semail) < 11 ;

Where in the first line->

semail is the column name I want to modify the data

10 - I'm keeping last 10 digits in the column, removing anything beyond 10

Second line ->

I'm adding 61 at the beginning of the each record where the record length is less than 11.

Regards,

Preetham