Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Lines Filter - REGEXP ^(10|20|30)

  1. #1

    Default Lines Filter - REGEXP ^(10|20|30)

    Hello,

    I'd like to filter all articles begining by 10, 11, 12, 13 and 20, so I made a regular expression like

    ^(10|11|12|13|20)

    but it doesn't work and I don't know why. It isn't taken into account.

    Thank you in advance for your help

  2. #2
    Join Date
    Sep 2007
    Posts
    834

    Default

    It should be like this:

    ^(10|11|12|13|20).*

  3. #3

    Default

    Hello!

    Thank you very much, it works!

    Why this .* added at the end? What does it mean?

    it should be indicated that it isn't a real regexp?

    Thank you for your help

  4. #4
    Join Date
    Sep 2007
    Posts
    834

    Default

    hi,

    The . means "any character"
    The * means "any number of repetitions"

    So the full expression means "starting with 10,11, etc., followed by 0 or more characters"

    Without .*, it only matches 10,11,12,13 and 20.

  5. #5

    Default

    Thank you very much Maria

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.