Regex expressions

[johndoe2487]

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.

[DanM]

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.

[Felipe_Ribeir0]

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:

[johndoe2487]

Need to pull the words from the email body field to answer the second half of number 5

[johndoe2487]

[Felipe_Ribeir0]

Hi @johndoe2487 

Try to use the regex tool in parse mode with these expressions

(?<=username\:)(.*?)(?=\s)

(?<=password\:)(.*?)(?=\s)

Example:

[johndoe2487]

okay so that only gave null values and then if they weren't null they were just blank for both username and password

[Felipe_Ribeir0 · Accepted solution]

Try the attached version

[johndoe2487]

Thank you! That worked, your help is greatly appreciated