Results 1 to 6 of 6
  1. #1
    ABW Ambassador
    Join Date
    January 4th, 2006
    Location
    USA
    Posts
    2,477
    ADVERTISERCATEGORY help please
    I've been using CJ datafeed for a few months. Thanks for some of the ABWers great posts on how to make it work . What I spent most of the time on is trying to create sub-categorys for "ADVERTISERCATEGORY" on CJ merchants' feeds.

    My question is: is there any way that I can "sub" the long "ADVERTISERCATEGORY" into one or two sub-cats on Excel?
    For example:

    From:
    ADVERTISERCATEGORY: Clothing>Women>Shirts>Long Sleeve

    to:
    MAINCAT:Clothing
    SUBCAT1:Women
    SUBCAT2:Shirts
    ...

    Besides, some merchants' ADVERTISERCATEGORY looks like this: Clothing,Long Sleeve Shirts, Women,(in different order or different name).It is always my biggest headache to try to unify them into the same form. It will be appreciated if somebody can help me on this one too

    Thanks in advance.

  2. #2
    ABW Ambassador
    Join Date
    January 18th, 2005
    Posts
    551
    I presume that you are using php.

    use http://uk2.php.net/manual/en/function.explode.php

    Then run through the array.

    voila

  3. #3
    Believe knight01's Avatar
    Join Date
    August 14th, 2006
    Location
    Dayton, Ohio
    Posts
    1,815
    Open the datafeed in excel

    Click to highlight the column next to the advertisercategory column

    Right click to insert one or two new columns (depending on how many sub categories you're dealing with)

    Click to highlight the advertisercategory

    Click the 'data' link at the top, you may need to expand beyond what it's default open is set.

    Look for "text to columns"

    Click text to columns and a window opens showing the now highlighted advertisercategory column.

    Make sure delimited is selected as an option on the page and click next.

    Change the delimiter to whatever delimiter is being used. Usually mine is ' > ' (right pointing arrow)

    Click finish

    Now your advertisercategory is split into however many subcats were listed.
    Someday starts today
    Military Discounts

  4. #4
    ABW Ambassador
    Join Date
    January 4th, 2006
    Location
    USA
    Posts
    2,477
    Knight01, thanks a lot. Should ask long time ago. You've made my day

  5. #5
    ABW Ambassador
    Join Date
    January 4th, 2006
    Location
    USA
    Posts
    2,477
    Wayder, thanks for the link. I'm not using php(still learning). Will check the link later

  6. #6
    Newbie
    Join Date
    July 26th, 2007
    Posts
    15
    Wow, Thx Knight01 too...

    and thx mayfly for asking ... I should have asked a long time ago too ..lol

  7. Newsletter Signup

+ Reply to Thread

Posting Permissions

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