You did not say in what form you would like the results. I am assuming that we will join them back to the main table.
One way is to tokenise the data, using " as a separator, and take every other token as the field names. Assuming a table called Data, and a field named Field, use code like:
// Tokenise the field:
T_Extract:
LOAD Field,
SubField(Field, '"') as tokens,
RowNo() as row
Resident Data;
// Get the base row number for each value of Field
Join(T_Extract)
LOAD Field,
Min(row) as minrow
Resident T_Extract
Group by Field;
// Concat tokens 1, 3, 5, .... (data inside the "s in the source) and join back to the main table
// (discard tokens 0, 2, 4, ... (data outside the "s)
Join(Data)
LOAD Field,
Concat(tokens, '|') as fieldlist
Resident T_Extract
Where Mod((row - minrow), 2) = 1
Group By Field;
DROP Table T_Extract;
Adapt to suit your table and field names. If you need the data in a different form, be more specific about your requirements and upload a sample qvw and a sample source file containing representative data.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
