3 Replies Latest reply on Sep 28, 2011 1:14 PM by philmodjunk

    Matching Names (almost)

    RyanFishy

      Title

      Matching Names (almost)

      Post

      FM pro 11, Windows 7.

       

      How do you construct a FileMaker field name that will match a text field with a trailing space using the 'matching names' approach.

       

      Example: I have a tab-delimited text file with a field (top row) as "Sequence " without the quotes.  How can i match field names with this?

      Edit: A field named "Sequence" will not match.  A field name typed in (manage DB) as "Sequence " will be created in filemaker as "Sequence" with the trailing space stripped.

      Thanks 

       

        • 1. Re: Matching Names (almost)
          philmodjunk

          You can't. You'd need to manually drag fields in this dialog to align the right fields with the columns of data in your tab file or edit the data in the tab file to strip out the spaces.

          BTW, this won't "create" a field like you describe, the data in the field simply won't get imported instead of being imported into the correct field.

          • 2. Re: Matching Names (almost)
            RyanFishy

            Ok thanks for the confirmation.  Interesting to note: when importing from a text file into a new table or DB. the tab delimited text header "Sequence " will cause FM to create a field named "Sequence" without the trailing space.  Which it then wont match on subsequent imports.

            • 3. Re: Matching Names (almost)
              philmodjunk

              Won't match on subsequent imports where the column name is "sequence "? That would be expected behavior as far as the field name matching goes and trailing spaces could cause problems with FileMaker names, so I'd prefer to see them trimmed like this anyway.