LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Filter node to search by text wildcard eg Name == "Travel*"

    Employee
    Posted 02-22-2013 05:06

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: CPRA

    How do you get a standard filter node (not using split by pattern) to be able to filter by text string wildcard eg 'Name' == "Travel*" or 'Company' = "*bank*"

    Thanks


  • 2.  RE: Filter node to search by text wildcard eg Name == "Travel*"

    Employee
    Posted 02-22-2013 07:16

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    where 'Name'.left(6)=="Travel" or 'Company'.strFind("bank") > -1


  • 3.  RE: Filter node to search by text wildcard eg Name == "Travel*"

    Employee
    Posted 02-22-2013 07:42

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: CPRA

    Thanks - wildcard search would be good for basic windows users!


  • 4.  RE: Filter node to search by text wildcard eg Name == "Travel*"

    Employee
    Posted 02-22-2013 07:57

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    I was trying to keep it simple.. for a more complex option, look in the help files for the function regexIsMatch()

    If you need documentation on the particulars of the Regular Expressions used by LAE, please check www.pcre.org