Jump to content
Dirigo

Export merge fields as .txt?

Recommended Posts

Hello all,

 

New to FM but have been going through the LinkedIn Learning modules and have a project in the works. I have a database of "listees" whose information I publish in a yearly directory (name, address, phone number, associations, etc.). I need to have this output to a .txt file (tab) so I can copy/paste into QuarkXpress, but am struggling to find an efficient way to do this. Using merge fields is ideal because I can add punctuation between the fields as opposed to exporting records, but I can't seem to find a way to export these fields to .txt in all my searches. 

Am I missing something or is this not possible? 

Thanks!

Share this post


Link to post
Share on other sites

use a script

set a variable  $path  = Get(DesktopPath) & myfile.txt  

use that to export a mer file that would include your headers,

If you are in FM18 you can create, open and write to a file and iterate thru adding a header row and then data rows all tab separated.

you could also build this data in to a single field then export field contents saving it as txt.

 

Share this post


Link to post
Share on other sites

You can export only field data, not layout objects such as text typed onto the layout (including fields merged in such text block).

To get the result you want, you can define calculation fields, for example:

LastName & ", " & FirstName

and export them instead of the original fields. Alternatively, export as XML and use a custom XSLT stylesheet to combine the fields and insert the punctuation.

--
P.S. I am not familiar with QuarkXpress but I would expect it to allow a similar manipulation to be executed during/after import.

 

Share this post


Link to post
Share on other sites

Thank you! I will look into calculation fields as that sounds exactly what I'm looking for. Still spending most of my time learning what is actually possible with this program! :)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.