Avatar

Level 2

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