Jump to content

Multiline data merge workaround

Recommended Posts

The situation is this - you're grumpy and truly love your word processor, the incomparable Mellel. Unfortunately, it doesn't support mail merge. You're grumpy. It's not like you're going to start using Word.

Affinity to the rescue, but there's a problem.

If you create a spreadsheet with multiline cells for addresses, Affinity will change the intra-cell newlines into spaces. For a year I railed against fate and hand edited merged envelopes and documents.

This morning an obvious solution came to mind.

In Numbers (or Excel, or whatever) do a global search and replace. Change every instance of "\n" to "¶\n" in the spreadsheet, merge in Affinity, and in Affinity replace every instance of "¶ " (pilcrow followed by space) to "\n".

Bingo, presto, Bob's your uncle, or whatever you say, multiline merge done without really much delay.

An added benefit is if you use the ¶ character you might be able to be that one guy on the writing team who still knows what a pilcrow is. That's worth a lot.

Link to comment
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.

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

Please note there is currently a delay in replying to some post. See pinned thread in the Questions forum. These are the Terms of Use you will be asked to agree to if you join the forum. | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.