topic Re: Property Expression Split with " as delimiter in Project data & BIM

Property Expression Split with " as delimiter

Matthew Johnson — Tue, 15 Sep 2026 01:55:26 GMT

Is it possible to use a SPLIT expression where the delimiter is " ?

We have long product names where the standard format is 'TYPE OF FINISH - MANUFACTURER PRODUCT "COLOUR"' and I'd like to be able to seperate the COLOUR component of the long name.

Operating system used: Windows

Re: Property Expression Split with " as delimiter

Barry Kelly — Tue, 15 Sep 2026 02:27:28 GMT

There are SPLIT functions in the expression editor.

It might be a multi-stage process though.

SPLITRIGHT to get COLOUR" and then SPLITLEFT that result to get just COLOUR.

The only problem then is the functions use the double quote symbol in the command.

I am not sure if you can change that.

So instead of "delimiter" - because """ (triple quotes) would make no sense, you can change it to a single quote 'delimeter' - so you will have '"' in the expression.

Changing to single quotes works in GDL, I can't say I have tried it in the expression editor.

Barry.

Re: Property Expression Split with " as delimiter

Matthew Johnson — Tue, 15 Sep 2026 03:34:36 GMT

Barry, thanks for the response. I understand the SPLIT functions in expression editing. My qeustion was more about if it is possible to use the double quote marks as delimiter as we have hundreds of surfaces in this format and would rather not rename all of them through all of our standards.

Some script languages allow you to use ASCI codes and the like to refer to a specific character rather than the actual character that has meaning in the script language.

Re: Property Expression Split with " as delimiter

Barry Kelly — Tue, 15 Sep 2026 04:06:40 GMT

That is why I suggested trying to change the quotes used in the expression to single quotes.

So ' " ' instead of " " " (spaces are just for clarity).

Barry.

Re: Property Expression Split with " as delimiter

Barry Kelly — Tue, 15 Sep 2026 04:17:31 GMT

Seems that doesn't work.

Barry.

Betreff: Property Expression Split with " as delimiter

Stefan L_ — Tue, 15 Sep 2026 05:20:32 GMT

Masking with a backslash should do the trick:

SPLIT ( <your property>; "\""; 2 )

Re: Property Expression Split with " as delimiter

Matthew Johnson — Tue, 15 Sep 2026 06:24:45 GMT

Thanks Stefan. I knew someone on here would know what the trick to masking was.

Betreff: Property Expression Split with " as delimiter

Barry Kelly — Tue, 15 Sep 2026 06:53:57 GMT

Thanks @Stefan L_

I thought there was something.

I tried that but must have used a forward slash. 🙄

Barry.