Hello. I want to extract strings anything comes before "|" . ex. Math | Math | Science | Math English | Math Science | Science | Science | Science Expected result: Math Math English Science Below search did not worked. my search | stats count by Subject="(?<Subject>[^\|]+)" Please help me out.   ... View more

There are over 10000 events and I want to extract events of 100 random Users. Is there any simple way to extract this? Thanks in advance! ... View more

Hello, I want to extract certain words only and exclude that comes after numbers. ex. Apple12ed Apple456ppp Orange234iw Banana7ye expected result: Apple  Orange  Banana  I have tried below, but the each string has different numbers and words, so the result is not correct. | eval Fruits = substr(Fruits, 1, len(Fruits)-4) incorrect Result: Apple Apple45 Orange2 Banan Thanks in advance. ... View more

Hello! I want to know how to count numbers of field values. Currently I have two fields, something like: User - Anna Class - Math, Science, English The “Class" field is a multivalued field, and i want the output to be something like this: User - Anna Class - Math, Science, English Class_Number - 3   Is there an easy way to count how many values are in a multivalued field and show it? Thanks in advance! ... View more