function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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 )