How do you form an ".in." clause?

jstrauss

• April 07, 2011 00:00

• Answered

Follow

Hi,

I can't find in the documentation an example of an ".in." statement. I want to use an ExtFilter with filters out data. I'm looking for various codes:

152W00000X
156FX1800X
156FX1201X
156FX1202X
...

Would someone kindly post an example of an .in. clause?

I only want records that match the code. Maybe there is a better mechanism than an .in. clause??

thanks
Jay

• 

  avackova

  • April 07, 2011 08:05

  0

  Comment actions Permalink

  Hello Jay,
  .in. operator serves to specify whether some value is contained in the list or in the map of other values, eg.:
  

  
  int value = 7;
  boolean is_in_list;
  is_in_list= value .in. [1, 2, 3 ,10, 50, 60];
  

  
  
  To find if some value matches a pattern you have to use regular expressions. Eg. to filter values, that contain "120" on position 6, you need to use filter expression like:
  

  
  $0.my_value ~= '\d{3}\w.120\dX'

  
  (See Pattern for regular-expression constructs)
• 

  jstrauss

  • April 08, 2011 02:15

  0

  Comment actions Permalink

  ah ha,
  
  Thanks:
  $0.HC_PROV_Taxonomy_Code_1 .in. ["152W00000X", "156FX1800X"]
  
  Works like you described. I couldn't find any example how to form the list. I was using ( ) instead of [ ]
  
  Thanks
  Jay

Please sign in to leave a comment.