Is there a way to traverse a log record line by line?

[labman]

I'm working on a complicated query on a single log record. Here is an example of log record:

I am the log record.
GROUP 1 (number 10000)
Alice
GROUP 2 (number 100)
Bob
GROUP 3 (number 10000)
Alice
(More groups....)

I need find out the number of groups with Alice and group number is greater than 1000. The query is straightforward to write if I can write ruby/python code. Is there a way to do this in Splunk?

Many thanks.