where() clause with Contains() in Data Filter

Reply
New Contributor
Posts: 2

where() clause with Contains() in Data Filter

Hi,

When I try to do the following, I get an exception:

dt1 << Data Filter(

  add Filter(

  columns(:MyCol),

  Where( contains(:MyCol, "A12") > 0)

  ),

  mode(show(1))

) << invert row selection;

And I get the following exception:

The WHERE clause has not been correctly specified. in access or evaluation of 'Greater'

How to accomplish what the code tries to do properly?

Super User
Super User
Posts: 7,413

Re: where() clause with Contains() in Data Filter

Hi,

You may want to post on: https://community.jmp.com/welcome

New Contributor
Posts: 2

Re: where() clause with Contains() in Data Filter

Ask a Question
Discussion stats
  • 2 replies
  • 231 views
  • 3 likes
  • 2 in conversation