AnsweredAssumed Answered

Text Formatting in Export-Import

Question asked by mikeo'neil on Feb 12, 2018
Latest reply on Feb 12, 2018 by mikeo'neil

Hi Folks,

 

Text Formatting Issue in Export & Import

FMP16.04-FMA 16.04

Mac & Windows

 

I have 3 tables that function as a library storing records I need to export. Each table only has a couple of fields I need to export. A Text field contains a Bullet at the beginning of the text entry for some records. Some Text records have an inline Trademark TM with the text.

 

I am exporting 3 different tables and then importing the same fields into 3 other tables meant for storing the data. This process occurs many times a day with about 100 records each cycle.

 

Export in Merge format.

Output file character set: Macintosh

Apply current layout data formatting… Selected

 

Import using Character set: Macintosh

 

The TM TM is not affected and appears correctly in the Imported text.

 

From what I have been reading on the forum is formatting is lost and I guess that also means the Bullet ?

 

Is there a work around, another keyboard character I could try, and should I be using a different Character Set with Export & Import?

 

Thanks-Mike

Outcomes