3 Replies Latest reply on Aug 6, 2010 4:57 PM by David40

    Text Fields



      Text Fields


      I am using FMP 9.  I have a text field that is normally all caps.  I uploaded some data that contained a combination of caps and non-caps.

      The text field is used for months.  Therefore, is "JANUARY" equal to "January" and/or "january"?

      I know its a simple question, but I have several thousand records that will need to be fixed if they are not equal.

      Thanks in advanced

        • 1. Re: Text Fields

          The fields will be treated as equivalent in sorts, finds, relationships and calculations.

          You can also clean up the capitalization on your entire table to make it consistent very easily by using a calculation with Replace Field Contents just to make it look nicer.

          • 2. Re: Text Fields

            Usually you would only worry about the display of the data which can be controlled by layout-level formatting to 'make it look nicer'.  So if you select the field and then Format > Text, you can set it to Title Case or whatever you wish.  Although true that case sensitivity won't usually matter in calculations, it does matter in Substitute() and Filter() and it would matter if the field is set as Unicode.

            However, when Users enter data, they mix caps all the time and it usually isn't an issue.  If you use Replace Field Contents[] remember two things, 1) it does not produce proper error trap when ran in multi-user so run it when nobody else is in the system and 2) it would only be 'fixed' until another User potentially types into the field.

            If it is very important to you that the data be exact then I would rather use auto-enter (with 'do not replace existing value...' unchecked) and apply the 'fix' there with calculation of Proper().  But I wouldn't bother in most cases.

            • 3. Re: Text Fields

              Thank you very much!  As usual, the Forum community has been a great help!