Posts by michellejames

    Hi there,


    I have product description with <BR> tag. I would like to replace with them new line break in excel. But unable to do it. If any suggest me for this so it will be great for me. I am doing manually yet.
    Example:
    description with <BR>


    Item Specifications: <br> Metal Type: Sterling Silver. <br> Metal Stamp or Hallmark: 925. <br> Metal Purity: 92.5% Sterling. <BR> Gemstone Creation Method: Simulated. <BR>Face Measurements From South To North: 7mm. <BR><br><br>Change the color of the metal to rose, yellow, black at additional charge. <br><br>Don't know your ring size?. <br>Here you can find a link to a conversion table of all ring sizes of all country's: (copy & paste into your browser). http://pics.bluenile.com/asset…_sizing_guide_0610-CA.pdf



    After new line insert result


    Item Specifications:
    Metal Type: Sterling Silver.
    Metal Stamp or Hallmark: 925.
    Metal Purity: 92.5% Sterling.
    Gemstone Creation Method: Simulated.
    Face Measurements From South To North: 7mm.



    Change the color of the metal to rose, yellow, black at additional charge.


    Don't know your ring size?.
    Here you can find a link to a conversion table of all ring sizes of all country's: (copy & paste into your browser). http://pics.bluenile.com/asset…_sizing_guide_0610-CA.pdf



    REgards

    Hi There,


    Greeting! I am very confuse to scrape from website. I dont know how to manage it.
    http://www.showmetheparts.com/catalog.html


    example
    01496
    01576
    1773
    2135



    1. I need to check each part number in above link of part number tab and collect " National Bearings & Seals" supplier of same part number data. I need to copy data for my screenshot "Buyers Guide-2.jpg". We can can not copy the data and paste. Please check my screen shot for more detail http://s30.postimg.org/a6fpf7vk1/Buyers_Guide_1.jpg


    http://s29.postimg.org/w87sj6d4n/Buyers_Guide_2.jpg


    2. Now I want to search each make, model and year in "Car & Truck Apps section" " scrape only " National Bearings & Seals". Always search Product: as “CLUTCH BEARINGS AND HYDRAULICS. Please check screen shot" Application Data.jpg".


    http://s23.postimg.org/maeci044b/Application_Data.jpg


    Can we scrape in two different excel sheet? both data.


    Very critical.



    Regards,

    Hi there,


    Greeting! I think my csv have some hidden special character which are not find out any way like manually, paste to check in text pad and note pad too. May software checking fail. I need msexcel expert opinion with solution. How to find and remove it. My csv upload successfully but not data import. I am tired now. Please take look on my csv. I am unable to attach ny csv. Hence attached my file in excel format.


    Regards,
    James

    Re: Try to fill the series at the of sku


    Hi StephenR,


    Greeting! Thanks for your reply. There is only one change that after count row the column C of result showing _1 with values i.e. "LEPR04_1" and previous situation it was showing only "LEPR04" in cloumn C. Right now i am manually moving the result down to up. Could you please resolve it?


    Regards,
    James

    Re: Try to fill the series at the of sku


    Hi Stephen R


    Greeting! Thanks for your reply. Here is the before and after detail


    Before


    [TABLE="class: grid, width: 215"]

    [tr]


    [td]

    Grand Count

    [/td]


    [TD="align: right"]1515[/TD]

    [/tr]


    [tr]


    [td]

    LEPR04 Count

    [/td]


    [TD="align: right"]7[/TD]

    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B0080ED9O2

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00BP4FYCE

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00MXBDBA0

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00AXBNG84

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00AKHC2EA

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00N7JIDGY

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00J4VT520

    [/td]


    [/tr]


    [tr]


    [td]

    DRG272 Count

    [/td]


    [TD="align: right"]4[/TD]

    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [TD="align: right"]6040546514[/TD]

    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [td]

    B00MXBDDPI

    [/td]


    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [td]

    B00D5SDECA

    [/td]


    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [td]

    B00L927OWK

    [/td]


    [/tr]


    [tr]


    [td]

    DRG273 Count

    [/td]


    [TD="align: right"]1[/TD]

    [/tr]


    [tr]


    [td]

    DRG273

    [/td]


    [td]

    B00AUXLXAI

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275 Count

    [/td]


    [TD="align: right"]7[/TD]

    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [td]

    B00ANL92TG

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [td]

    B00MXBDGAU

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [td]

    B00AKH9Y8W

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [td]

    B00JNALXCM

    [/td]


    [/tr]


    [/TABLE]

    After

    [TABLE="class: grid, width: 329"]

    [tr]


    [td]

    Grand Count

    [/td]


    [TD="align: right"]1515[/TD]

    [td][/td]


    [/tr]


    [tr]


    [td]

    LEPR04 Count

    [/td]


    [TD="align: right"]7[/TD]

    [td][/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B0080ED9O2

    [/td]


    [td]

    LEPR04_1

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00BP4FYCE

    [/td]


    [td]

    LEPR04_2

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00MXBDBA0

    [/td]


    [td]

    LEPR04_3

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00AXBNG84

    [/td]


    [td]

    LEPR04_4

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00AKHC2EA

    [/td]


    [td]

    LEPR04_5

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00N7JIDGY

    [/td]


    [td]

    LEPR04_6

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00J4VT520

    [/td]


    [td]

    LEPR04_7

    [/td]


    [/tr]


    [tr]


    [td]

    DRG272 Count

    [/td]


    [TD="align: right"]4[/TD]

    [td][/td]


    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [TD="align: right"]6040546514[/TD]

    [td]

    DRG272_1

    [/td]


    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [td]

    B00MXBDDPI

    [/td]


    [td]

    DRG272_2

    [/td]


    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [td]

    B00D5SDECA

    [/td]


    [td]

    DRG272_3

    [/td]


    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [td]

    B00L927OWK

    [/td]


    [td]

    DRG272_4

    [/td]


    [/tr]


    [tr]


    [td]

    DRG273 Count

    [/td]


    [TD="align: right"]1[/TD]

    [td][/td]


    [/tr]


    [tr]


    [td]

    DRG273

    [/td]


    [td]

    B00AUXLXAI

    [/td]


    [td]

    DRG273_1

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275 Count

    [/td]


    [TD="align: right"]7[/TD]

    [td][/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [td]

    B00ANL92TG

    [/td]


    [td]

    DRG275_1

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [td]

    B00MXBDGAU

    [/td]


    [td]

    DRG275_2

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [td]

    B00AKH9Y8W

    [/td]


    [td]

    DRG275_3

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [td]

    B00JNALXCM

    [/td]


    [td]

    DRG275_4

    [/td]


    [/tr]


    [/TABLE]


    Please check and let me know your comment.


    Regards,
    james

    Re: Try to fill the series at the of sku


    Hi StephenR,


    I need some changes in above result


    like


    [TABLE="class: cms_table, width: 339"]

    [tr]


    [td]

    DRG275

    [/td]


    [TD="colspan: 2"]B00ANL92TG[/TD]

    [td]

    DRG275_1

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [TD="colspan: 2"]B00MXBDGAU[/TD]

    [td]

    DRG275_2

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [TD="colspan: 2"]B00AKH9Y8W[/TD]

    [td]

    DRG275_3

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [TD="colspan: 2"]B00JNALXCM[/TD]

    [td]

    DRG275_4

    [/td]


    [/tr]


    [/TABLE]



    I am trying to update the formula but not succeed. Can you please suggest me.


    Regards,

    Re: remove html attribute tag on excel sheet


    Hi jindon,


    Greeting! Thanks for your reply. I have rung your test and test2 macro. I need result like test2 but this macro fail row#3, 6, 7, 9. Can you please check you macro on my sample excel file? Class are still exist in span, ul, li...etc. I dont understand that why the class not removed? Kindly please check again.


    Regards,
    James

    Hi There,


    I am tried to create macro for remove html attribute tag form my excel sheet cell. like <div id="description-content" class="tabContainer " style="overflow: hidden; outline: 1px solid blue;"> into <div>....etc. many html tags in my excel sheet. It should be clean html tag. Also &nbsp character want to remove. Please check my excel sheet for more detail.



    Regards,
    james

    Hi There,


    Greeting! I am trying to create the macro for fill the series at the end for every sku. But unfortunately not succeed. Please check the example below


    Before
    [TABLE="width: 215"]

    [tr]


    [td]

    sku

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Grand Count

    [/td]


    [TD="align: right"]1515[/TD]

    [/tr]


    [tr]


    [td]

    LEPR04 Count

    [/td]


    [TD="align: right"]7[/TD]

    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B0080ED9O2

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00BP4FYCE

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00MXBDBA0

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00AXBNG84

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00AKHC2EA

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00N7JIDGY

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [td]

    B00J4VT520

    [/td]


    [/tr]


    [tr]


    [td]

    DRG272 Count

    [/td]


    [TD="align: right"]4[/TD]

    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [TD="align: right"]6040546514[/TD]

    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [td]

    B00MXBDDPI

    [/td]


    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [td]

    B00D5SDECA

    [/td]


    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [td]

    B00L927OWK

    [/td]


    [/tr]


    [tr]


    [td]

    DRG273 Count

    [/td]


    [TD="align: right"]1[/TD]

    [/tr]


    [tr]


    [td]

    DRG273

    [/td]


    [td]

    B00AUXLXAI

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275 Count

    [/td]


    [TD="align: right"]4[/TD]

    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [td]

    B00ANL92TG

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [td]

    B00MXBDGAU

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [td]

    B00AKH9Y8W

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [td]

    B00JNALXCM

    [/td]


    [/tr]


    [/TABLE]


    After


    [TABLE="width: 339"]

    [tr]


    [td]

    sku

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Grand Count

    [/td]


    [TD="align: right"]1515[/TD]

    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    LEPR04 Count

    [/td]


    [TD="align: right"]7[/TD]

    [td]

    |

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [TD="colspan: 2"]B0080ED9O2[/TD]

    [td]

    LEPR04

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [TD="colspan: 2"]B00BP4FYCE[/TD]

    [td]

    LEPR04_1

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [TD="colspan: 2"]B00MXBDBA0[/TD]

    [td]

    LEPR04_2

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [TD="colspan: 2"]B00AXBNG84[/TD]

    [td]

    LEPR04_3

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [TD="colspan: 2"]B00AKHC2EA[/TD]

    [td]

    LEPR04_4

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [TD="colspan: 2"]B00N7JIDGY[/TD]

    [td]

    LEPR04_5

    [/td]


    [/tr]


    [tr]


    [td]

    LEPR04

    [/td]


    [TD="colspan: 2"]B00J4VT520[/TD]

    [td]

    LEPR04_6

    [/td]


    [/tr]


    [tr]


    [td]

    DRG272 Count

    [/td]


    [TD="align: right"]4[/TD]

    [td]

    |

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [TD="align: right"]6.04E+09[/TD]

    [td][/td]


    [td]

    DRG272

    [/td]


    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [TD="colspan: 2"]B00MXBDDPI[/TD]

    [td]

    DRG272_1

    [/td]


    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [TD="colspan: 2"]B00D5SDECA[/TD]

    [td]

    DRG272_2

    [/td]


    [/tr]


    [tr]


    [td]

    DRG272

    [/td]


    [TD="colspan: 2"]B00L927OWK[/TD]

    [td]

    DRG272_3

    [/td]


    [/tr]


    [tr]


    [td]

    DRG273 Count

    [/td]


    [TD="align: right"]1[/TD]

    [td]

    |

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    DRG273

    [/td]


    [TD="colspan: 2"]B00AUXLXAI[/TD]

    [td]

    DRG273

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275 Count

    [/td]


    [TD="align: right"]4[/TD]

    [td]

    |

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [TD="colspan: 2"]B00ANL92TG[/TD]

    [td]

    DRG275

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [TD="colspan: 2"]B00MXBDGAU[/TD]

    [td]

    DRG275_1

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [TD="colspan: 2"]B00AKH9Y8W[/TD]

    [td]

    DRG275_2

    [/td]


    [/tr]


    [tr]


    [td]

    DRG275

    [/td]


    [TD="colspan: 2"]B00JNALXCM[/TD]

    [td]

    DRG275_3

    [/td]


    [/tr]


    [/TABLE]


    Kindly let me know if any solutionozgrid.com/forum/core/index.php?attachment/63091/ozgrid.com/forum/core/index.php?attachment/63091/ for it. Right now I am adding it manually.


    Regards,
    James

    Re: Need help to look values of the respective sku in different column


    Hi KjBox ,



    Greeting! Thanks for the code. It working fine. Yes, i have post my query two forum due to no one give answer in that forum. Sorry for delay replying due to out of office. I have change the header and try. It working excellent.



    I want to scrapped the large images from amazon product page. but unable to scrapped due to java script code. Can we extract the large images or large image url of every swatch color like black, red...etc? As you see the they are in roll over image function? The page is full java script.

    http://www.mrexcel.com/forum/e…rge-image-url-amazon.html



    http://www.amazon.com/dp/B002O5I2JA/ref=twister_B000BJR2WE


    Regards,
    James