AnsweredAssumed Answered

Strip Numbers from an Address?

Question asked by GeoffreyMartin on Aug 29, 2012
Latest reply on Aug 29, 2012 by raybaudi


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?