Sample of using if condition in advance mode in an action

Question

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.

Mohan_Dugganab · Accepted Answer

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}
	)
)

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded