Extract Street Name from Address Field

[sc_print]

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.

[rpaterick]

Try this out.

 

If you have ABC 1234 Main Street it should return ABC Main Street.

 

return Field("field").replace(/[1234567890]/g," ");

[rpaterick]

Try this out.

 

 

modified the code. I had "." as a character to take out from the initial post. You'd probably need that in your directional characters.