Hey everyone, I have a bit of a problem extracting certain words from a string to make new variables. I know that the scan function can normally be used to solve this problem quite easily, but the problem I have is that some of the entries for the new variable contain more that one word. For example (using an address): 123 Main Street, Los Angeles, California, 11000 123 North Main Street, Los Angeles, California, 11000. As is stands right now, those addresses are lumped into one variable. I want to extract the strings so I have a distinct variable for: Street, City, State, and Zip Code. The problem with using a basic SCAN function is that streets with two-word names are not captured correctly. Does anyone have a solution??
... View more