Results 1 to 2 of 2
  1. #1
    ABW Ambassador Nature Boy's Avatar
    Join Date
    January 18th, 2005
    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.
    Click finish.
    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."

  2. #2
    ABW Ambassador Mike O's Avatar
    Join Date
    January 17th, 2005
    Los Angeles area
    Good tip, good detailed explanation.

    Thanks -- I can use this!

    -- Mike

  3. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. - Affiliate Tip, Unique Hot Categories ...
    By Andy Rodriguez in forum Andy Rodriguez Consulting
    Replies: 6
    Last Post: May 28th, 2006, 05:00 PM
  2. Excel question
    By SSanf in forum Programming / Datafeeds / Tools
    Replies: 9
    Last Post: February 6th, 2006, 03:25 PM
  3. Need Help with Excel
    By Rhea in forum Programming / Datafeeds / Tools
    Replies: 8
    Last Post: June 1st, 2005, 03:32 AM
  4. another way to load up excel?
    By oscar in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: September 7th, 2004, 01:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts