help with Subfield

[Anonymous]

I have a product field that I would like to break out the subparts for use in a drill down. All the data is in one column.

QT110M

QT110M_1

QT110M_2

QT110M_3

I tried using the below script to parse them out. Which works ok. But the Part Name Sub field only give me the Number.

Upper(subfield(PROD_SPEC_FLD7,'_',1)) as Part_Name,
Upper(subfield(PROD_SPEC_FLD7,'_',2)) as Part_Name_Sub

,

What I would like to be able to do is seperate them out but still have the full name. Because I drill down its nots real intuitive what 1, 2 and 3 equal.

How can parse out the feild names with an underscore and then still capture the whole name.

Thank you for any help you can provide.

Cassadi

[m_woolf]

Add:

PROD_SPEC_FLD7 as Part_Name_All;

[Anonymous]

I dont think that will quite work. I want to pull out the feilds with the _1, _2 as a another field but I want to see the whole feild as QT110M_1  and QT110M_2 not as just 1 and 2.