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
