How to parse single field into multiple

[#1]

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

[swuehl]

LOAD

    subfield(Matter,'_',1) as Seg,

    subfield(Matter,'_',2) as Sub,

    subfield(Matter,'_',3) as type,

     subfield(Matter,'_',4) as LOC,

...

FROM ...;