Hello Experts,
I'm trying to update a mobile number format using journey.
I want to add multiple conditions, like
if mobile number 0023456789 then update +23456789 in new_mobile column,
if mobile number 023456789 then update +23456789 in new_mobile column etc.
trying with some syntax:
if substr(mobile_number,0,2) == '00', '+' +substr(mobile_number,2,15),
Could someone please help how can I ingest value in one filed using conditions in other field.
Solved! Go to Solution.
Views
Replies
Total Likes
Try validating it on the following lines
if (substr(#{ExperiencePlatform.ProfileFieldGroup.profile.mobilePhone.number},0,2) == '00')
then ('+'+(substr(#{ExperiencePlatform.ProfileFieldGroup.profile.mobilePhone.number},2,length(#{ExperiencePlatform.ProfileFieldGroup.profile.mobilePhone.number}))))
else (
if ( (substr(#{ExperiencePlatform.ProfileFieldGroup.profile.mobilePhone.number},0,1) == '0'))
then ('+'+(substr(#{ExperiencePlatform.ProfileFieldGroup.profile.mobilePhone.number},1,length(#{ExperiencePlatform.ProfileFieldGroup.profile.mobilePhone.number}))))
else (
#{ExperiencePlatform.ProfileFieldGroup.profile.mobilePhone.number}
)
)
Try validating it on the following lines
if (substr(#{ExperiencePlatform.ProfileFieldGroup.profile.mobilePhone.number},0,2) == '00')
then ('+'+(substr(#{ExperiencePlatform.ProfileFieldGroup.profile.mobilePhone.number},2,length(#{ExperiencePlatform.ProfileFieldGroup.profile.mobilePhone.number}))))
else (
if ( (substr(#{ExperiencePlatform.ProfileFieldGroup.profile.mobilePhone.number},0,1) == '0'))
then ('+'+(substr(#{ExperiencePlatform.ProfileFieldGroup.profile.mobilePhone.number},1,length(#{ExperiencePlatform.ProfileFieldGroup.profile.mobilePhone.number}))))
else (
#{ExperiencePlatform.ProfileFieldGroup.profile.mobilePhone.number}
)
)
Thank you so much for such quick response!
Views
Replies
Total Likes
Views
Likes
Replies