Is it possible to trim a string down to a particular character? For example, I want to have both categories and subcategories in my directory. I have a table called categories. I have to relate the subcategories with the categories. Categories and subcategories are named as follows:
Cat1
Cat1::Subcat1
Cat1::Subcat2
Cat1::Subcat3
Cat2
Cat2::Subcat1
Cat3
Cat3::Subcat1
Cat3::Subcat2
The two colons are used only for this example. They can be replaced with any delimiter.
When subcategories appear in the web pages, of course, I don't want the category name to appear as part of it. Therefore, I need to remove all characters up to the 2nd colon.
Is it possible to trim off all characters up to a delimiter and what is the proper delimiter to use?
Brian