I’m using a group shape and a child shape. I created a new shape inside the child shape to retrieve the box name of each row from the table. I also want to filter the name using regex since I don’t need the full name, but I’m not sure how to do that. When I pass the parameter ID (8926), it returns the entire name.
I want to extract the text that comes after "hd-". If the string doesn’t contain "hd-", it should display the full name instead.
Hi Ramesh,
This isn’t the simplest thing to pull off, but it can be done.
You’ll need to nest the parameter placeholder inside a regexreplace placeholder in the shape’s text.
Using the text below worked for me:
[RegexReplace:MyRegex,[param:[this elementid],502,[TableIndex]],]
Note that the shape should also have the ForcePropertyFromParent option so the [this elementid] placeholder uses the context of the element containing the table.
[RegexReplace:MyRegex,[param:[this elementid],502,[TableIndex]],] i didn't get this. Should I replace something on this? What is 502
Under what property should I use this?
That is the parameter ID containing the text, see https://docs.dataminer.services/dataminer/Operator_guide/Visio/reference/Placeholders_for_variables_in_shape_data_values.html#paramdmaidelementidparameteridtablerow in your case it's 8926.
[RegexReplace:.*-hd-,[param:[this elementid],8926,[TableIndex]],]
you mean something like this. And place in under shape data "text" property?
No, place it directly into the shape (as text), do not use the text shape data. In case it doesn't work, you need to take it one step at a time (first start with your param placeholder and make sure it returns the text)
Note that you can paste the text directly in the shape, so it's not using any Text shape data.