I'm using FMPro for Mac, which is my default database. I regularly export my records from FM as tab-delimited, and then import my records into other programs, as my data changes. One of my primary targets is Apple's Address Book . . . this is so I can sync with my phone, etc.

In FM, I have a comment field that I would like things listed on different lines. For example,

Steve - 584939

Karen - 998373

When I export my records from FM, each record is obviously separated by a paragraph return. What can I do within a text field in FM to show the line break . . . that . . . when I export my data, will be recognized as a line break and not a paragraph return? (And do I need to choose a specific character set in the export?)

Once imported, Apple's Address Book either shows no break

Steve - 584939Karen - 998373

or some weird symbols

Steve - 584939013u2028Karen - 998373

Any suggestions?

Steve

I found the answer. "n" (without the quotes) is the code that Address Book recognizes as a line break.