Help with Regular Expression

[zwolfpack]

Regularly confusing!! Glad you got it working.

[ServiceXp]

Thank you so much guys. The solution provided by zwolfpack and AllHailJ worked.

I generally stay far far away from "Regular" (nothing regular about them) Expression but really needed to use it here.

Again, Thank You!

[AllHailJ]

Let's get back to basics

Here is a website that will allow you to test your Regex.

https://regex101.com/

Here is a site with cheatsheet of Regex syntax.

https://www.rexegg.com/regex-quickstart.html#chars

Here is the text String I utilized to test the regex: "Midway was recently added to TV sHows temPa MovIes "

The Regex that will identify the wanted terms regardless of case is: \b((?i)(?<!Temp\s)Movies|Sports|TV\sShows|TV\sRecordings)\b

In the test, It identified both "TV sHows" and "Movies". This is because Temp did not precede Movies but temPa did. If you delete the a it will find TV sHows only.

I think this will work in the long run regardless of text before or after.

[zwolfpack]

Thanks for you help, neither seemed to work. Would not fire the event.

Given your example, try this instead

(Movies|Sports|TV|Shows|TV Recordings)$

or

added to (Movies|Sports|TV|Shows|TV Recordings)$

The '$' at the end indicates that the substring has to be at the end of the given string. My previous suggestion with the '^' at the start indicates that the string needs to start with the substring. (With both the '^' and the '$', the string has to match the substring exactly, which turns out not to be what you wanted).

[ServiceXp]

Try

^(Movies|Sports|TV|Shows|TV Recordings)$

or

^Movies$|^Sports$|^TV Shows$|^TV Recordings$

Thanks for you help, neither seemed to work. Would not fire the event.

[ServiceXp]

Do you want to test a string that just contains movies, Sports, TV Shows, TV Recordings?

Can you Share the Strings you are trying to parse?

Yes, here is what a possible string would look like.. They could contain other/additional verbiage but this is the jist of it.


Midway was recently added to Movies

[zwolfpack]

Try

^(Movies|Sports|TV|Shows|TV Recordings)$

or

^Movies$|^Sports$|^TV Shows$|^TV Recordings$

[AllHailJ]

Do you want to test a string that just contains movies, Sports, TV Shows, TV Recordings?

Can you Share the Strings you are trying to parse?

[ServiceXp]

Try this- This is searching for words on a word boundary.

\b(Movies|Sports|TV|Shows|Recordings)\b

Thank you! It now fires the event, so that's a much better result then I got..

HOWEVER

It fires on any word in the group and not on the exact statements below.

Example: If the status is Temp Movies, it firing (I'm guessing because it has the work Movie in it), but I need to only fire on the full Strings

Movies
Sports
TV Shows
TV Recordings

[AllHailJ]

Try this- This is searching for words on a word boundary.

\b(Movies|Sports|TV|Shows|Recordings)\b

[ServiceXp]

I'm trying to match these possible strings inside a device status within a longer string. I've been at this for a few hours and I'm calling uncle...

Any help is much appreciated.

Movies
Sports
TV Shows
TV Recordings