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.
LinkedIn
Twitter
