3 Replies Latest reply on Aug 29, 2012 11:24 AM by raybaudi

    Strip Numbers from an Address?



      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?