Skip to main content
Question

Attribute Validator "In" List Validation

chris_rmw
Contributor
Forum|alt.badge.img+2

I am using the attribute validator to test a list of pavement marking line marking types coming from a AutoDesk SDF. The validator is throwing false errors when I use the "In" Validation

The list of values in the rule configuration are: Broken 1-1,Broken 1-8,Broken 3-3,Broken 3-6,Broken 3-9,Double Solid,Simultaneous Solid/Brkn-1,Simultaneous Solid/Brkn-2,Solid

Everytime I run my workbench Broken 3-3 is reported as an error even though I've verified that the spelling is correct.

I've also tried subbing out the commas with double quotes and it doesn't seem to work either.

 

4 replies

M
Forum|alt.badge.img+2
  • markatsafe
  • August 13, 2021

@chris_rmw​ I reproduced your issue (attached FME 2021.1). The problem is that In can also include ranges - see the Validation Rules in the AttributeValidator docs.  FME is picking up the 3-3 as a range instead of including it in the "Broken 3-3". You can workaround the issue by quoting the problem In values (which seems to be most of them).

Broken 1-1,Broken 1-8,"Broken 3-3",Broken 3-6,Broken 3-9,Double Solid,Simultaneous Solid/Brkn-1,Simultaneous Solid/Brkn-2,Solid

 We'll see if we can get this fixed. 

M
Forum|alt.badge.img+2
  • markatsafe
  • August 13, 2021

example in FME 2021.1

chris_rmw
Contributor
Forum|alt.badge.img+2
  • chris_rmwContributor
  • Author
  • Contributor
  • August 13, 2021

@Mark Stoakes​ Thanks that fixed my issue!

no_id
Contributor
  • no_idContributor
  • Contributor
  • November 7, 2023
markatsafe wrote:

@chris_rmw​ I reproduced your issue (attached FME 2021.1). The problem is that In can also include ranges - see the Validation Rules in the AttributeValidator docs.  FME is picking up the 3-3 as a range instead of including it in the "Broken 3-3". You can workaround the issue by quoting the problem In values (which seems to be most of them).

Broken 1-1,Broken 1-8,"Broken 3-3",Broken 3-6,Broken 3-9,Double Solid,Simultaneous Solid/Brkn-1,Simultaneous Solid/Brkn-2,Solid

 We'll see if we can get this fixed. 

@markatsafe did this ever get fixed? 

Reply


Helpful Members This Week

Community Stats

31,332
Posts
118,863
Replies
38,957
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.