1 Reply Latest reply on May 27, 2010 1:04 PM by TSGal

    Sorting hyphenated or two word name

    hansvd

      Summary

      Sorting hyphenated or two word name

      Description of the issue

      I have a problem sorting names eg, Di-Silva or Van Dorssen.Sorting them will also pick up the S and D.Is there a way that the sort only looks at the first letter ?Hansie

        • 1. Re: Sorting hyphenated or two word name
          TSGal

          hansie:

           

          Thank you for your post.

           

          When you sort by a Text field, it will start with the first character in that field.

           

          Perhaps you are looking at the Index.  Put your cursor in the field, pull down the Insert menu and select "From Index...".  In that dialog box, there is a checkbox to Show individual words.  This allows you to see each word in the Name field.  For your example, you would see:

          Di

          Dorssen

          Silva

          Van

           

          If unchecked, then you see the two entries:

          Di-Silva

          Van Dorssen

           

          Is this what you are referring?

           

          TSGal

          FileMaker, Inc.