Menu

wild cards / field not empty

Anonymous
2020-10-09
2020-10-13
  • Anonymous

    Anonymous - 2020-10-09

    Is there a way to filter for "field not empty" by using some sort of wild card that means any character?
    Thanks.

     
  • Bruce Martin

    Bruce Martin - 2020-10-09

    looks like no; I will update program

     
  • Bruce Martin

    Bruce Martin - 2020-10-10

    You can use a regular expression check of:

    • .*[^-\s].*

    see atached picture:

     

    Last edit: Bruce Martin 2020-10-10
  • Anonymous

    Anonymous - 2020-10-12

    Thanks. Very Strange but I'll try it. What does it mean?

     
  • Bruce Martin

    Bruce Martin - 2020-10-13

    Google Regular Expressions or look at info.

    The expression

    Basically

    • . - any character.
    • *- any number of repeats of the preceding character

    So is .* is any character string (0 or more characters

    [^-\s] means any character that is not white space (space tab).

    So .*[^-\s].* is

    • Chacter string of any length
    • Noon blank character
    • Chacter string of any length
     

Anonymous
Anonymous

Add attachments
Cancel