Regex expressions
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am confused about how to create a regex expression that matches whether the "email body" contains the words "username" and "password" anywhere in the field - the field is string.
Solved! Go to Solution.
- Labels:
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I would suggest posting sample data as REGEX troubleshooting needs to see how the data is structured and what comes before and after what you want to parse out.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @johndoe2487
If you want help with your specific problem, please share a sample of the data. If you want to understand more or less how to solve by yourself, here is one example that you could understand better and adapt for your situation.
Input:
Workflow + result:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Need to pull the words from the email body field to answer the second half of number 5
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @johndoe2487
Try to use the regex tool in parse mode with these expressions
(?<=username\:)(.*?)(?=\s)
(?<=password\:)(.*?)(?=\s)
Example:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
okay so that only gave null values and then if they weren't null they were just blank for both username and password
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you! That worked, your help is greatly appreciated
