+7Hi,
Can i use a testfilter on a concatenated field?
For example
record1 = concatenated field contains "Aqf; Aqf,"
record 2 = concatenated field contains "Aqf; Mrl, Mrl"
record 3 = concatenated field contains " Als; Als"
I would want a filter that gives me all records where the value in the concatenated field is the same (Aqf: Aqf) and "Als: Als) or i want to have the records where one of the values of the
concatenated field is Aqf
The concatenated field is already the result of a list.
+18Hi @nath for the fixed values its a matter of defining the test clause, for the second test have a llok at the contain and IN operators.
Hope this helps.
+7Maybe it's a stupid question but i don't know how to define the cause for the first one. I can compare with other values in other records but not whitin the same record in the same attribute? This doesn't work :-)
+18Maybe it's a stupid question but i don't know how to define the cause for the first one. I can compare with other values in other records but not whitin the same record in the same attribute? This doesn't work :-)
use-testfilter-on-a-concatenated-field.fmw
Hi @nath, If I understand the requirement correctly, this works.
If there could be several kind of delimiter character (e.g. comma, semicolon, and colon), you can use the StringReplacer (regular expression mode) to unify the delimiter characters to an identical one (e.g. comma) beforehand.
Hi @nath, If I understand the requirement correctly, this works.
If there could be several kind of delimiter character (e.g. comma, semicolon, and colon), you can use the StringReplacer (regular expression mode) to unify the delimiter characters to an identical one (e.g. comma) beforehand.
+7Maybe it's a stupid question but i don't know how to define the cause for the first one. I can compare with other values in other records but not whitin the same record in the same attribute? This doesn't work :-)
Thx but i have a thousand differents combinations and i can't all define them in the filter :-)
+7Thx, i think that would work if i have two values in the concatenated field, but what if there are more? 3, 4, 5, it's for each record different.
Thx, i think that would work if i have two values in the concatenated field, but what if there are more? 3, 4, 5, it's for each record different.
+15@nath
Use a regular expression (.+;\\s\\1)|(.*Aqf.*)
in Tester
[{(.+;\\s\\1)|(.*Aqf.*)} {YourAttribute}] = 1
Or in string searcher
(.+;\\s\\1)|(.*Aqf.*)
(u have a space after the semicolon, that's the reason for the \\s in the expression)
\\1 is the first capturegroup wich is the .+
+15@nath
...correction first capture group is in parentheses so...
(.+);\\s\\1
To complete correction...add wordboundaries \\b )works now a days in stringsearcher..)
(\\b.+\\b);\\s*\\1$
And when repeats more the 2 times..
(\\b.+\\b);\\s*(\\1,*)+$
So total regexp would look like
(\\b.+\\b);\\s*(\\1,*)+$|(.+;.*Aqf.*)
