Strip Numbers from an Address?
I'm working in Filemaker 11. I have addresses that are imported from another source. My goal is to sort by street. I was thinking if I could make a calculation field that would strip the numbers out of the address, I could sort by that field. I'm not sure what that calculation would look like. Then what about streets that are numbers (20th street). Any ideas?