- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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
Views
Replies
0 Likes
Total Likes