topic Re: Trim Text in an Expression in Collaboration with other software

Trim Text in an Expression

fuzzytnth3 — Mon, 16 Sep 2019 14:20:46 GMT

I want to create a Property so I can Label some Composite Walls but I would like to "Trim" off a Revision Number. We add to our Composite Names (the Rev Number lets us know we are using the most recent version as we have a number of Models using a number of Modules)

So for example our Composite name is "LIN_01a-02" where the "-02" is the Revision Number. So I want an Expression that trims off the "-02" and displays a result of "LIN_01a"

I've tried various Text function but ArchiCAD kicks up the message below

https://my.pcloud.com/publink/show?code=XZhyQHkZRJA5E5af6DksA2LIrKss57pSlguy

Any idea how I can get this to work?

Re: Trim Text in an Expression

fuzzytnth3 — Mon, 16 Sep 2019 15:27:16 GMT

Well I got it to work but not in a clever way that can cope with having longer or shorter Composite names

LEFT ( Composite Structure, 7 )

The above works but only if the Composite name is 7 characters long. What I would like to do is be able to look for the Hyphen in the Composite name and display everything to the left of the Hyphen. I remember you can do this with IFC properties but I've not managed to get Expressions to work like that.

So if anyone has sussed how to do that then I would be very grateful if you could let me know how

Re: Trim Text in an Expression

poco2013 — Mon, 16 Sep 2019 19:18:07 GMT

SPLITLEFT ( {Property:General Parameters/Composite Structure}, "-", 1 )

Re: Trim Text in an Expression

fuzzytnth3 — Tue, 17 Sep 2019 07:25:53 GMT

Brilliant thank you that is exactly what I was after