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

    -----------------------------
    Scott

    "Can't we all just get along? Only when we've been drinking."

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

    Thanks -- I can use this!

    -- Mike

  3. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. JewelBasket.com - Affiliate Tip, Unique Hot Categories ...
    By Andy Rodriguez in forum Andy Rodriguez Consulting
    Replies: 6
    Last Post: May 28th, 2006, 06:00 PM
  2. Excel question
    By SSanf in forum Programming / Datafeeds / Tools
    Replies: 9
    Last Post: February 6th, 2006, 04:25 PM
  3. Need Help with Excel
    By Rhea in forum Programming / Datafeeds / Tools
    Replies: 8
    Last Post: June 1st, 2005, 04:32 AM
  4. another way to load up excel?
    By oscar in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: September 7th, 2004, 02: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
  •