Jump to content
You must now use your email address to sign in [click for more info] ×

Datenzusammenführung Zeilenumbruch in einem Datenfeld nicht mehr möglich bei Publisher V2


Mihafri

Recommended Posts

Hallo,

ich möchte einen harten Zeilenumbruch, also mit ALT+ENTER in die Datenquelle im Datenfeld einfügen, um es bei der Datenzusammenführung auch übernommen wird. Leider geht es bei der V2 nicht mehr. Bei der V1 Version ging es ohne Probleme. 

Wie kann ich das ermöglichen?

Z.B.:
Es soll so aussehen in einem Feldinhalt:
Name >ALT+ENTER
Adresse >ALT+ENTER
Email > ALT+ENTER

Hinweis: Da es in dem Feld auch mehr als 3 Zeilen geben kann, wollte ich nicht eine extra Datenfeld in der Datenquelle einfügen.
Es ist kompakter und einfacher wenn es in einem Datenfeld einzutragen und übernommen werden würde.

Link to comment
Share on other sites

  • 3 weeks later...
7 hours ago, Mihafri said:

Kann mir jemand behilflich sein zu dieser Frage?

Ich nicht direkt, weil ich mich mit der Datenzusammenführung (noch) nicht so genau auskenne.
Aber vermutlich erhältst mehr Rückmeldungen, wenn du deine Frage auf Englisch formulieren würdest.

MacBookAir 15": MacOS Ventura > Affinity v1, v2, v2 beta // MacBookPro 15" mid-2012: MacOS El Capitan > Affinity v1 / MacOS Catalina > Affinity v1, v2, v2 beta // iPad 8th: iPadOS 16 > Affinity v2

Link to comment
Share on other sites

Hello,

I would like to insert a hard line break, i.e. with ALT+ENTER in the data source in the data field, so that it is also adopted in the data merge. Unfortunately, it no longer works with the V2. With the V1 version it went without problems. 

How can I make this possible?

For example:
It should look like this in a field content:
Name >ALT+ENTER
Address >ALT+ENTER
Email > ALT+ENTER

Note: Since there can be more than 3 lines in the field, I didn't want to add an extra data field in the data source.
It is more compact and easier if it would be entered and taken over in a data field.

Translated with DeepL

Link to comment
Share on other sites

  • 1 month later...

Did you get any results??

I would like to add another question to yours . . . .

How can I get rid of the empty line, that is automatically generated by an empty column in Excel??

Sometimes there are additional Information that are not in every line in excel.

For example:

Name: Peter Mustermann

Street: Am Hof 1

Addition to adress: Appartment 609

City: 51145 Cologne

 

Name: Klaus Mustermann

Street: An der Bitz 4

Addition to adress:

City: 53115 Bonn

 

Hope you get what I mean ;-)

In other Programs like InDesign ther is a function to ignor empty columns while importing from Excel.

Is this also possible in Affinity??

 

Link to comment
Share on other sites

I haven't gotten a solution yet, but I'm putting a each line separately in a field with no line breaks. This is more cumbersome and requires more table fields but it works then.

Regarding your question, I don't have a solution but to try it would be the following: in the table field where there is no text, you could put a space. Maybe this could work then.

Link to comment
Share on other sites

On 3/27/2023 at 12:01 AM, Ilja said:

In other Programs like InDesign ther is a function to ignor empty columns while importing from Excel.

Is this also possible in Affinity??

Sadly the answer is no.

Mac Pro (Late 2013) Mac OS 12.7.4 
Affinity Designer 2.4.0 | Affinity Photo 2.4.0 | Affinity Publisher 2.4.0 | Beta versions as they appear.

I have never mastered color management, period, so I cannot help with that.

Link to comment
Share on other sites

22 minutes ago, Mihafri said:

image.png.fb6809b85d23256df698e95e4b03728f.png

Tried it but i didn’t work so far.

thanks for all replies!!! I did a workaround to get the job done. Splitted the excel job in three different parts, imported the data and exported the jobs in 3 pdf files that i finally merged together for the printjob.

cheers to evrybody!!!

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.

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.

Loading...
×
×
  • Create New...

Important Information

Terms of Use | 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.