SOLVED

Split a Postal Code into Two Values? Or just pick first three letters?

Go to solution
MarkAutoMation
Level 1

Split a Postal Code into Two Values? Or just pick first three letters?

Hi everyone,

 I have an interesting scenario.

 

I need to create a Smart Campaign to only pick from the first three letters of a postal code. 

However, if in this postal code like A1A 1B1 and B2A 1A1 for example, I ask Marketo to use CONTAINS A1A... Marketo will technically match both postal codes and possibly assign the wrong next step in the campaign.

I am trying to figure this out.  I tried "Starts With" but it doesn't work at all and just picks the wrong one.

 

Do I have any alternatives?  I was thinking if I have POSTAL CODE stored and then have a Smart Campaign to write only the first three digits to another field, it would perfectly work.  But how do I do that?

 

Is there an alternative to what I am trying to do?

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Split a Postal Code into Two Values? Or just pick first three letters?

There's no reason Starts With would not work here, unless you're misrepresenting the whitespace and there's actually leading space.

View solution in original post

1 REPLY 1
SanfordWhiteman
Level 10 - Community Moderator

Re: Split a Postal Code into Two Values? Or just pick first three letters?

There's no reason Starts With would not work here, unless you're misrepresenting the whitespace and there's actually leading space.