Remove Apartment Number from Address Field 1

[socalvelo]

CR 14
SQL Server

I'm working with street addresses.

Need to remove apartment numbers if one exists. # precedes an apartment number. example: N MAIN ST #A

I need to remove # and everything afterwards. My formula removes #, but I'm not sure how to get rid of what's to its right.


if {vw_locations.street_name} like "*#*" then replace({vw_locations.street_name},"#","")
else

{vw_locations.street_name}

 

[lbass]

Use:

If “#” in {vw_locations.street_name} then
Trim(Split({vw_locations.street_name},”#”)[1]) else
{vw_locations.street_name}

Be sure to replace my quote marks with your own if you copy this.

-LB

 

[socalvelo]

Thanks LB. Worked perfectly.