AnsweredAssumed Answered

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

Question asked by kessingb on Mar 28, 2014
Latest reply on Apr 2, 2014 by TSGal

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

Outcomes