Find value between

Hi,

I’m trying to get relevance to return a value from a text file.

((following text of first “,” of it as trimmed string) and (preceding text of first “;” of it as trimmed string) of lines whose (it starts with “Wake Up on Alarm”) of it) of file “C:\Lenovo_BIOS_Wake_settings.log”

Log file contents:

Wake Up on Alarm,User Defined;[Optional:Single Event,Daily Event,Weekly Event,Disabled,User Defined]

I need the whole statement to return ‘True’ if the value after the first ‘,’ and before ‘;’ is “User Defined.” What I have isn’t doing it. What am I doing wrong?

Results: E: The operator “first” is not defined.

q: following text of first "," of preceding text of first ";" of lines whose (it starts with "Wake Up on Alarm") of file "C:\lenovo_bios_wake_settings.log"
A: User Defined
T: 1.178 ms

q: exists it whose (it starts with "Wake Up on Alarm" AND following text of first "," of preceding text of first ";" of it as string = "User Defined") of lines of file "C:\lenovo_bios_wake_settings.log"
A: True
T: 0.651 ms
4 Likes

Awesome!!! Thank you very much.