For testing I have this custom measure:
ExtractString('(xsd),(abc),(abc),(xyz)','.*\(([^,)]*)\),\(\1\).*',1)
According to the docu ExtractString uses java pattern matching and trying the same in java (Online Compiler and Editor/IDE for Java, C, C++, PHP, Python, Ruby, Perl - Code and Run Online, replacing single ‘\’ by ‘\\’) or on (https://regex101.com/ for java8) yields the expected “abc” as result but when executed in an easzybi measure there is no result.
Hi @aherz,
Could you please clarify what is the objective for this calculation? What kind of data are expected to be input and what would yuo like to get as output?
Best,
Zane / support@eazyBI.com
Hi Zane,
I want to find pairs of tuples in the string ‘(xsd),(abc),(abc),(xyz)’ that have the same content.
So running the provided regexp on the provided string should yield “abc”, see here (group 1 on rhs is “abc”):
So this seems to be a bug in ExtractString. The actual problem I am trying to solve in eazybi I solved already by some other means, I just wanted to report this potential bug.
