Expand my Community achievements bar.

Your voice matters! Help shape the future of Adobe Journey Optimizer by sharing your feedback.
SOLVED

Sample of using if condition in advance mode in an action

Avatar

Level 4

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.

1 Accepted Solution

Avatar

Correct answer by
Employee

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

 

View solution in original post

2 Replies

Avatar

Correct answer by
Employee

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

 

Avatar

Level 4

Thank you so much for such quick response!