SOLVED

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

Go to solution
MarkAutoMation
Level 1

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?

When life lends you lemons, make applesauce.
Tags (1)
1 ACCEPTED SOLUTION
SanfordWhiteman
Level 10 - Community Moderator

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

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