Extract Values Surrounded by Quotes

[Jucodeo]

Hello Alteryx Community,

I am trying to parse out queries to obtain the pulled fields. The fields will always be surrounded by single quotes. I tried parsing a quote as a delimiter, which seemed to work. However, I also retrieved additional parts of the query, such as IF, FROM, and EQUALS clauses. Is there a way to retrieve the field names? 

Here is an example. I would only like to retrieve the green values in the 'Fields' column.

Query	Fields
Select 'Employee' Like TEST and 'Report Number' and 'Payment Date' From 2024-01-01 To 2024-01-02	Select
Select 'Employee' Like TEST and 'Report Number' and 'Payment Date' From 2024-01-01 To 2024-01-03	Employee
Select 'Employee' Like TEST and 'Report Number' and 'Payment Date' From 2024-01-01 To 2024-01-04	Like TEST and
Select 'Employee' Like TEST and 'Report Number' and 'Payment Date' From 2024-01-01 To 2024-01-05	Report Number
Select 'Employee' Like TEST and 'Report Number' and 'Payment Date' From 2024-01-01 To 2024-01-06	and
Select 'Employee' Like TEST and 'Report Number' and 'Payment Date' From 2024-01-01 To 2024-01-07	Payment Date
Select 'Employee' Like TEST and 'Report Number' and 'Payment Date' From 2024-01-01 To 2024-01-08	From 2024-01-01 To 2024-01-02

[vizwithdan]

Hi Justin,

Try the attached and let me know if that makes sense. 

Thanks

Danny