I have a property "numbers" which contains values seperated with a pipe symbol:
[property:numbers] = 234|214|34|4Is there a way to express that I want to split this string with the seperator | and only use the 1. 2. 3. or 4. part in a visio?
Hi Dominik,
I see that this question has been inactive for some time. Do you still need help with this? If not, could you select the answer that has been most helpful for you (using the ✓ icon)?
It did not work on [property:…] It had to be rewritten to [parameter:…] then RegexMatch worked.
I found a regex...
https://regexr.com/885h9
...but it's quiet a challange to select the nth occurance for each field now.
[RegexMatch:([^|;]+),[property:numbers]] Isn''t working.Do you have any example?
Hi Dominik, this should be possible using the "index" option.
The resulting command will be something like Regexmatch:([^|;]+),[property:numbers],index=0 to select the first number of the list.
Hi Michiel, I managed to get a result, if I enter the numbers directly, but it doesn't accept the nested [property:numbers]. Maybe because it does not expect a srting. The search terms seems to be programmed without quotes at least.
To add a bit more detail to this answer, the solution was to rewrite to use [parameter:…] instead of [property:…] (as mentioned above).
Hi Dominik, this should be possible using the "index" option.
The resulting command will be something like Regexmatch(([^|;]+),[property:numbers],index=0) to select the first number of the list.