2 Replies Latest reply on Apr 2, 2014 10:06 AM by TSGal

    Copying a column from an excel table brings the tab as well

    kessingb

      Summary

      Copying a column from an excel table brings the tab as well

      Product

      FileMaker Pro

      Version

      >11 (12 &13)

      Operating system version

      OS X or Windows  any version

      Description of the issue

      Copying a column from excel to a text field brings an extra character (the tab character) from excel to the end of the line for each cell (line in the text field when pasted into FileMaker field).

      Steps to reproduce the problem

      1) Select multiple values from a single column in MS Excel.
      2) Paste the selected text into a text field in FM12 or FM13.
      3) You can see that it has a "tab" character at the end of each line within the text field.

      Expected result

      Just the text should have been copied with a carriage return at the end of each line

      Actual result

      A tab and a carriage return are pasted into the field

      Exact text of any error message(s) that appear

      NA

      Configuration information

      NA

      Workaround

      NA