Find the first numeric character from a string value

[SEUAdmin]

Hello all!, 

I have a column with data where i need to extract addresses from, all rows have a few random characters before the addresses, something like "HUD 123 Street name, City , State, Zipcode" or "HI-ECO 123 Street name, City, State, Zipcode, I am looking for an expression which it can extract just the address part, removing the characters in front. I have not been able to figure it out.

I have tried IF(contains([Job Description],1),MID([Job Description],FIND("1",[Job Description]),40),"")

I was going build one that searches for 1 thru 9 as all the addresses starts with a numeric value, but it stills gets me an error no matter what I try, the mentioned above, works when finds 1 at any part of the string value, if  "1" is found at the zip code, I only get partial of the zip code in return.

[AleksiAlkio]

You can find the first number with LEFT(EXTRACTNUMBERS([Job Fescription]),1) and then find the first position with FIND()

[Denny774]

Hey man,

you could try this:

MID(
    [Job Description],
    (FIND(" ", [Job Description]) + 1),
    LEN([Job Description])
)