Jump to content

Extract Street Name from Address Field


Recommended Posts

I have an address field where I need to extract just the street name. As an example, if the data in the address field is "123 Main St.", I need to return just "Main St.". My thought was to use a trim statement to remove anything from the left up to, and including, the first space, but I'm not having success. Any help would be appreciated. Thanks.
Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...