Results 1 to 4 of 4
  1. #1
    Newbie
    Join Date
    January 18th, 2005
    Posts
    25
    Help With Category Separation in Datafeeds
    I have a feed with categories that are broken down into subcategories. The problem is that the subcats are a branch off of the category column and not intheir own subcat column in excel....

    For example:

    DC Comics > Alex Ross Justice League
    DC Comics > Batman
    DC Comics > Batman Begins

    I only want to show DC Comics in my category tree along with other names like hasbro, mattel, etc... when I generate the index page, I get each version of CD Comics > ...etc.

    Anyone know how to only have DC Comics show up without having to manually delete every entry in the feed that has a "category > subcat" structure?

    thanks

  2. #2
    Affiliate Manager nish's Avatar
    Join Date
    July 6th, 2005
    Posts
    762
    Rodski,

    In Excel, First create an extra column next to the category column. Now select the entire category column. Go to Data -> Text to Columns.. Select 'Delimited' and click on Next. Select 'Others' and in the space next to Others, enter '>'. Click Next & then click Finish.

    So now the category column will only have DC Comics. If you wish, you can delete the new column with sub-categories.

    Hope this helps.

    cheers!
    -nishith

  3. #3
    Newbie
    Join Date
    January 18th, 2005
    Posts
    25
    It worked great! thanks a lot!

  4. #4
    Affiliate Manager nish's Avatar
    Join Date
    July 6th, 2005
    Posts
    762
    Quote Originally Posted by Rodski
    It worked great! thanks a lot!
    Glad it worked!

    cheers!
    -nishith

  5. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Datafeeds - title, description, category - SEO?
    By x-man in forum Programming / Datafeeds / Tools
    Replies: 9
    Last Post: January 12th, 2011, 05:00 PM
  2. Replies: 0
    Last Post: February 25th, 2009, 02:51 PM
  3. Poll: Are the Category Datafeeds Useful?
    By Melody Christensen in forum BettyMills
    Replies: 2
    Last Post: January 24th, 2006, 10:30 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
  •