Skip to main content

Hi folks, I’m struggling to figure out a very specific regex pattern matcher. I need to extract some question answers from an email job application using the plain text field extracted from the email. These are single word answers as so:

This is an employer-written question. You can report inappropriate questions to Indeed through the 'Report job' link at the bottom of the job description. 'Do you have experience providing care in the UK?'

Yes

This is an employer-written question. You can report inappropriate questions to Indeed through the 'Report job' link at the bottom of the job description. 'What is the first half of your postcode?'

Wv12

This is an employer-written question. You can report inappropriate questions to Indeed through the 'Report job' link at the bottom of the job description. 'Do you drive and have access to a vehicle?'

Yes

This is an employer-written question. You can report inappropriate questions to Indeed through the 'Report job' link at the bottom of the job description. 'What is your mobile number?'

07490128369

 

I’ve been trying:
(?<=vehicle\?\'\s).*(?=This is)
vehicle\?\'(\w+)

 

But no luck. Any ideas?

Hi @PeterCera 

Some other options to try with email parsing…

Email Parser by Zapier: https://zapier.com/apps/email-parser/integrations#triggers-and-actions

Mailparser: https://zapier.com/apps/mailparser/integrations#triggers-and-actions


@PeterCera 

Here’s an alternative using a JavaScript Code step: https://zapier.com/apps/code/help

 

 

RESULTS

 


Thanks so much @Troy Tessalone - really helpful to see a java solution - it’s more elegant than regex for sure!