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 by lines which field X (string) contains "abc"

    Employee
    Posted 12-23-2014 06:13

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

    Originally posted by: Denis Drouais

    Hello,

    With the Filter node, I am trying to delete all lines which field "Reference" does not contain "abc". For instance :

    Reference, Volume
    Reference abcd, 13
    Reference ab, 4567
    Reference abc, 2218
    Reference a, 955
    Reference abcdef, 9888
    Reference abe, 6550

    Should give :

    Reference, Volume
    Reference abcd, 13
    Reference abc, 2218
    Reference abcdef, 9888

    I'm trying the the folowing code

    emit *
    where Reference == "*abc*"

    but it gives me 0 output

    Can anybody help me with it ?

    Thank you very much in advance,
    Denis


  • 2.  RE: Filter by lines which field X (string) contains "abc"

    Employee
    Posted 12-23-2014 06:47

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

    Originally posted by: ryeh

    Try this:

    emit *
    where 'Reference'.strFind("abc") > -1


    String find (strFind) returns -1 if no match is found, hence the > -1.


  • 3.  RE: Filter by lines which field X (string) contains "abc"

    Employee
    Posted 12-26-2014 07:15

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

    Originally posted by: Denis Drouais

    It works perfectly well. Thank you!