Strip away part of value in Data tag with script?

[MarcelP102]

Is it possible to strip away a part of the value of the data tag? We uses 'zones' in de rooms to define the function of the space. The default output shows '[Ruimtefunctie]-Verblijfsruimte' I want it to show up as 'Verblijfsruimte'. Could this be done with a script in the data tag like:

 

REPLACE(#Space#.#11_Zone_1#, '[Ruimtefunctie]-', '')

 

Unfortuantly this is not working.. Any help?

[Pat Stanford]

Try #WS_Substring(Space.11_Zone_1, '-', 2)#

 

This should return the second part of your string after the dash.  If you have multiple dashes it will only return the second part.

 

Note that inside the #WS you have to use pure Worksheet format, you can't use the Data Tag # versions.

[MarcelP102]

Hi pat, Thanks for your replay. Shomehow it doent show the value but the title of the labelfield. See attachment for sample file. Apreciate it a lot if you could take a look.

 

 

 

 

Data tag mistery.vwx

[Pat Stanford]

No idea.

 

I opened your file and saw the wrong value. 

 

I then edited the Data Tag Style and the Layout. I selected the placeholder text and clicked the Define Tag Field button in the OIP. I noted that the formula was what I expected. When I exited the Tag Style, the value updated to what we expected.

 

Please try the above. And if it works, then try a new file and import the tag style and see if it works there as well.

 

Mystery to me also.

[MarcelP102]

Sorry for the late replay. Thanks for checking. If it works for you but not for me it could be that my localized version of VW has a bug. I will wait till sp4 is out in my country and if the bug remains contact support.

[MarcelP102]

The sollution was to replace the , with ; (as your signature saids)