Exporting a Carriage Return

[Steve J]

Quick question... I have an address book database with a calculation field that computes a vCard for that individual. Pretty simple, really, except that I need the lines in the calculation field to export with carriage returns, not line feeds. I have tried using a global field with a return chacter pasted in, but that didn't work. Any other ideas?

(By the way, I have tried the xml vCard export file... it works on the local machine, but I have not figured out how to use xml files on a remote machine with a served database. That's another issue, I suppose)

[CobaltSky]

Hi Steve,

FileMaker utilises the carriage return character as a record delimiter in exported data sets, which is why it routinely substitutes line feeds for CRs in all exports.

There are various shareware products, however, that provide ways around this, mostly in the form of plug-ins that enhance export functionality. A few of the better known examples are:

Troi Automatisering - Troi File:

http://www.troi.com/software/fileplugin.html

Waves in Motion - oAzium FileTools:

http://wmotion.com/filetools.html

Protolight - File Toolbox:

http://www.geocities.com/SiliconValley/Network/9327/plPLUGs.html

Comm-Unity Networking Systems:

http://saveit.cnsplug-ins.com/

... and there are others. In each case, you can download a free demo version from the vendor URL and check out the options.

[cjaeger]

(By the way, I have tried the xml vCard export file... it works on the local machine, but I have not figured out how to use xml files on a remote machine with a served database. That's another issue, I suppose)

just make sure you post the XSL to a web server or any location that is accessible to all clients. (I often use dynamically generated XSL via text export)