Split a Postal Code into Two Values? Or just pick first three letters? | Community
Skip to main content
M
MarkAutoMation
New Participant
December 11, 2020
Solved

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

  • December 11, 2020
  • 1 reply
  • 1538 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

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

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
December 11, 2020

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

Terms & ConditionsAccessibility statement

Loading footer...