AnsweredAssumed Answered

sort alpabeticaly

Question asked by pmozz1 on Feb 18, 2010
Latest reply on Feb 18, 2010 by RickWhitelaw


sort alpabeticaly


im new and dont know much about filemaker but here's my problem.  When my dad createed his data base Idk 12-13 years ago he put the adress name and house number in the same feild fo instance  1313 eastway is in one feild.  so my question is we now need to arange 12 years of adress alpabeticaly but when we do a search and try to sorth them they sork acording to number not street name is there anyway to get them to sort by street names.. some one told my i could add a caculation feild that would look at the address then move right till it foud a space then use the data but i have no idea how to do this if anyone could help or know a beter way to do it would be greatly apreciated. im using filemaker pro 10 on a mac.  thanks