Hyphens doesn't word wrap nicely like spaces. S’abonner
Hi, I'm using a small circular label (11 mm) and thus the font needs to be as large as possible.
I am using the "paragraph" text and I have one field which has the most characters and I would like it word wrapped nicely to maximise the font.
However, when the field has hyphens, it doesn't line feed like a spaces does. I have tried to use the Transform function to 1. Search for hyphen-minus (-) and Insert zero-width space (U+200B) after to force a line feed where appropriate and 2. Search for hyphen-minus and replace with soft hyphen (U+00AD). It didn't seem to work as shown below. Seems like Unicode isn't supported; I get an error regarding invalid characters when clicking Test.
I have also tried using the Character Template function; it always looks good for one entry but bad for the others. For example my template is ???????@-?\n% and any white space from the database no longer word wraps nicely especially if there are no hyphen-minus at all.
Does anyone have a good suggestion or workaround? I could use VBscript as well but I couldn't figure out the right code to get it to work. Basically I'm trying to get the hyphen-minus to behave like a keyboard space - to wrap nicely without breaking at inappropriate parts or by adding zero-width space which the search and replace Transform didn't support. I'm also avoiding having to add spaces manually to the database.
Anyway this is my database csv file:
Vous devez vous connecter pour laisser un commentaire.