Has anyone ever had to extract just street number from an address like in this example:
1200 14th Ave S.
And the number we want is the "house number" or 1200?
I'm working with a client who does canvassing (door-to-door fundraising) and they want to be able to select a range of house numbers in a report. So that they can assign a block of houses to a specific canvasser.
@Nonprofit Success Pack @Fundraising @Salesforce.org System Administrators
5 个回答
+1 @Justin Barss there's a great example of this in the Online Help entry for the FIND Function =>
https://help.salesforce.com/HTViewHelpDoc?id=customize_functions_a_h.htm&language=en_US#FIND