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.
You can find the first number with LEFT(EXTRACTNUMBERS([Job Fescription]),1) and then find the first position with FIND()
Hey man,
you could try this:
MID(
[Job Description],
(FIND(" ", [Job Description]) + 1),
LEN([Job Description])
)
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |