Could you perhaps upload a minimal workspace that reproduces the issue? It would be very helpful.
I tried but now both raised defence (man-made) and sea defence (man-made) fail :-s
av-example.fmw
Try double-quoting all the list elements:
"coastal","defence","sea defence (man-made)","raised defence (man-made)","sea"
Seems to be the - (dash) character that's the problem. I'll check with the developers and file a request to fix. In the meantime, as @david_r says, enclose the values in quotes in the AttributeValidator and all is OK.
Filed with developers. Reference: PR#80254
Try double-quoting all the list elements:
"coastal","defence","sea defence (man-made)","raised defence (man-made)","sea"
It solved the problem in the test one and it is now working in my main dataset thank you. However, it's now failing to recognize - flood_gate, i've tried it with and without " "
It solved the problem in the test one and it is now working in my main dataset thank you. However, it's now failing to recognize - flood_gate, i've tried it with and without " "
I think you'll need to provide another workspace with an example of that. When I try it, it works for me.
Our developer says she will try and fit a fix into FME2018. So, no guarantees, but it will hopefully be fixed very shortly.
Try double-quoting all the list elements:
"coastal","defence","sea defence (man-made)","raised defence (man-made)","sea"
I think this is a defect of the Help on the AttributeValidator.
Regarding the In operator, the help says "A list of values in which you are testing for a certain value. The Right Value is a comma-delimited list of values, or a range". However, there is no description about how you can set a "range" by the In operator and how you can test strings that contain a hyphen with the In operator.
In the Help on the Tester, there is this description.
"String ranges (i.e. a-d) can also be specified. If you want to test for values that contain a hyphen, those values should be enclosed in quotation marks. For example, if x=LL-27, then x In "LL-27","LL-83" would be true. On the other hand, x In LL-27,LL-83 would be false. This is because LL-27 and LL-83 are treated as two empty string ranges, since numbers are ordered earlier than letters when considered as strings."
I think the same description should be added to the Help on the AttributeValidator.