I have a property “numbers” which contains values seperated with a pipe symbol:
[property:numbers] = 234|214|34|4
Is 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,
You could achieve this with the proposal of Miguel, but I highly suggest to explore the new placeholder that is better fit for this use case!
Kind Regards,
Jarno
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.