Subject:How Do I clean TXT File? Author:raj desai Date:08 Sep 2010 11:15 PM
I just downloaded the stylesutdio today. I have a text feed that I want to convert in to XML so I tried that. I however noticed that one section of the feed needs editing. My question is - how can I do that?
<Product_Type>Jewelry & Watches > Fine Jewelry > Rings</Product_Type>
In above product_type - the data are: Jewelry & Watches > Fine Jewelry > Rings
They are all in single column. I would like to separate them in to three columns:
1. Jewelry & Watches
2. Fine Jewelry
3. Rings
That way - when I map it to my master schema - I can appropriately carry out that function. Such as I can put Rings into Jewelry > Rings for my master schema.