Results 1 to 2 of 2
December 27th, 2003, 09:15 AM #1
I just posted this in a merchant's forum (Generic Gifts), and thought I'd pass it along here, unless it's already common knowledge.
The problem is, there are quite a few feeds out there that are using a category structure like this:
Main > Sub > Sub2 > etc
Basically, they is only one category column, which also includes the sub categories.
Here's my solution:
Open the feed with Excel (I'm using Excel 97)
Copy the entire MAIN CATEGORY column.
Create a new document (workbook).
Paste the column into the document (workbook).
Click the DATA tab and select TEXT TO COLUMNS.
Select DELIMITED, then click next.
Select the OTHER delimiter and put a > in the box beside it.
You now have all of the sub-categories seperated into columns.
Name the new columns whatever you wish.
Paste these columns back into the feed and save.
"Can't we all just get along? Only when we've been drinking."
December 27th, 2003, 09:46 AM #2
Good tip, good detailed explanation.
Thanks -- I can use this!
By Andy Rodriguez in forum Andy Rodriguez ConsultingReplies: 6Last Post: May 28th, 2006, 05:00 PM
By SSanf in forum Programming / Datafeeds / ToolsReplies: 9Last Post: February 6th, 2006, 03:25 PM
By Rhea in forum Programming / Datafeeds / ToolsReplies: 8Last Post: June 1st, 2005, 03:32 AM
By oscar in forum Programming / Datafeeds / ToolsReplies: 2Last Post: September 7th, 2004, 01:33 PM