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.  How do I do a countif in LAE?

    Employee
    Posted 09-19-2013 07:12

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

    Originally posted by: zon

    Hi,

    I want to count how many comma a certain field has, because I know there should not be over 5 comma, and I want to find the lines with more than 5.
    Is there any formula fo that in LAE?
    I search in LAE and here for some topic, but could find none.

    Tanks for your help.

    Regards
    ZON


  • 2.  RE: How do I do a countif in LAE?

    Employee
    Posted 09-19-2013 08:18

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

    Originally posted by: rboccuzzi

    Sure ZON,

    NumberOfCommas = 'someField'.split(",").len() - 1

    Cheers
    Rich