Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I have a field in excel called Matter and data looks as follows:
ABC_PAT_Trademark_test
How can I parse group into a different field?
So ABC would be Seg
PAT would be Sub
Trademark would be type
and test would be LOC
LOAD
subfield(Matter,'_',1) as Seg,
subfield(Matter,'_',2) as Sub,
subfield(Matter,'_',3) as type,
subfield(Matter,'_',4) as LOC,
...
FROM ...;