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 |
