ShowAll Questionssorted byDate Posted
rornelas

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