Label Style Formula to get text to paragraph

gradylawless
gradylawle…
26.08.2014 - 12:05

Hello,

I am looking for a way to be able to have a Label style that pulls the name of the project and splits it over how many lines it needs to fit into an area of my label.

For example, the project name is "[0000G]Test Project & Build in London" and I need it to come out as:

However, all I have managed to do is to get this:

For which I use the following formula - "MID(@405@;8,50)" This returns the text after character number 8 with up to 50 characters. Now this is great if the title of the project isn't very long, but if it goes over 40 or so characters it overflows the box I have made for it, like so.

Does anyone know if there is a way of making this text start to paragraph if it reaches a set number of characters?

Cheers,

Grady

Judy_AllplanFR
Judy_Allpl…
05.09.2014 - 19:12

Hi,

There is no other possibility actually.

You can use one field and create a formular with the commande "MID()" to divide the field.

Or you can use 2 attribut or another attribut just for this case.

Good Use!

Mr Judy GURAVADU
Responsable Technique Préfabrication & Ingénierie
Precast Sales & Support

Allplan France & Allplan Software Engineering

Depuis 2006

gradylawless
gradylawle…
09.09.2014 - 09:08

The problem with using two MID commands as such:

MID(@405@;8;40) <-- This takes the first 40 characters after the 8th character.
MID(@405@;48;40) <-- This takes the first 40 characters after the 48th character.

This will mean that words will get split, and the title wouldn't make sense. In excel you would use look up commands, however I have had no luck using any other excel commands in the formula editor aside from the ones listed in the formula window its self.

Does all plan allow the use of additional excel formula? Or is it exclusively just the list given? Are there any plans to update to support more commands, doing so would allow us to create completely automated title blocks based of just a few variables.

Thanks,

Grady