Im using the AttributeValidator to test words appears in my .csv file. It finds the following no problem - raised defence (man-made), but it keeps failing for the following - sea defence (man-made), even thought it appears in the list to test for. I have checked spelling and made sure there are not any extra spaces but it doesnt seem to recognize the word in the .csv file. Has anyone else had a similar problem?
Best answer by david_r
Try double-quoting all the list elements:
"coastal","defence","sea defence (man-made)","raised defence (man-made)","sea"
Try double-quoting all the list elements:
"coastal","defence","sea defence (man-made)","raised defence (man-made)","sea"
+56
Try double-quoting all the list elements:
"coastal","defence","sea defence (man-made)","raised defence (man-made)","sea"
+56
+56
Try double-quoting all the list elements:
"coastal","defence","sea defence (man-made)","raised defence (man-made)","sea"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.