+ Start a Discussion
rornelasrornelas 

Trim text before numeric values start

Hi Everyone,

Im looking for a formula field to trim text before street address. For example my street addresses are all entered this way " p/o maria Jenkins 123 West way Ave". An ideal solution would trim any text before the address and only leave me with "123 West way Ave". The address will always start with a numeric values.

Is this even possible with a formula field?
sridhar sivaramansridhar sivaraman
Hi,

Hope this helps.

BLANKVALUE( MID(MailingStreet ,

MIN(
IF(contains(MailingStreet, "0"), find("0",  MailingStreet ), LEN(MailingStreet )+1),
IF(contains(MailingStreet, "1"), find("1",  MailingStreet ), LEN(MailingStreet )+1),
IF(contains(MailingStreet, "2"), find("2",  MailingStreet ), LEN(MailingStreet )+1),
IF(contains(MailingStreet, "3"), find("3",  MailingStreet ), LEN(MailingStreet )+1),
IF(contains(MailingStreet, "4"), find("4",  MailingStreet ), LEN(MailingStreet )+1),
IF(contains(MailingStreet, "5"), find("5",  MailingStreet ), LEN(MailingStreet )+1),
IF(contains(MailingStreet, "6"), find("6",  MailingStreet ), LEN(MailingStreet )+1),
IF(contains(MailingStreet, "7"), find("7",  MailingStreet ), LEN(MailingStreet )+1),
IF(contains(MailingStreet, "8"), find("8",  MailingStreet ), LEN(MailingStreet )+1),
IF(contains(MailingStreet, "9"), find("9",  MailingStreet ), LEN(MailingStreet )+1)
),

LEN(MailingStreet )), MailingStreet )