12 {{ upvoteCount | shortNum }}
12 {{ upvoteCount | shortNum }}

software to extract url?

by freeabs
12 replies
Hi,

Is there a software or a method that I can extract certain info from a URL easily?

For example in this URL, hxxps://www.amazon.com/gp/product/B0154N44QS/ref=s9_cartx_gw_g421_i2_r?ie=UTF8&fpl=fresh&pf_rd_ m=ATVPDKIKX0DER&pf_rd_s=&pf_rd_r=3CEJ2SA91XEEGWS3J 0EQ&pf_rd_t=36701&pf_rd_p=a0732ba3-2c28-420f-893e-6aca94d77e48&pf_rd_i=desktop

I want to extract only the portion between.... /product/B0154N44QS/ref=s9, meaning I only need the number B0154N44QS

Right now I am doing it manually. Is there a method, script, website where I can easily extract the info I want as shown above? The before and after parameters are always the same.
#extract #software #url
  • Profile picture of the author AdWordsUzmani
    I don't think you can find any tool for that. But why don't you use notepad or something like that.

    Just paste your urls and replace before and after parameters with blank string.
    {{ DiscussionBoard.errors[10793993].message }}
    • Profile picture of the author freeabs
      Originally Posted by AdWordsUzmani View Post

      I don't think you can find any tool for that. But why don't you use notepad or something like that.

      Just paste your urls and replace before and after parameters with blank string.
      There are many url's to go through so it will be tedious to find and replace everytime. Maybe I need a script for that.
      Signature

      More In Depth Training CLICK HERE TO FIND OUT MORE

      {{ DiscussionBoard.errors[10793998].message }}
  • Profile picture of the author ydsimple
    You can find on fiver coder who will create program for you for your needs. :-)
    {{ DiscussionBoard.errors[10794010].message }}
  • Profile picture of the author selfdisciplineacademy
    Copy all the links to a software program..

    ..then highlight it all and 'change' the surrounding text into 'BLANK'

    I've used this method before for ads and research.
    Signature

    [CENTER][B]==> Do you want to make money online? [/B]
    Free video: How regular people are making 6-figures per month on the internet! [URL="http://www.clkmg.com/fc27/UDCL-IN2WF"][B]Watch this free video now![/B][/URL] <==[/CENTER]

    {{ DiscussionBoard.errors[10794044].message }}
  • Profile picture of the author Anky
    You can use microsoft excel functions. Search on Google for the same.
    How you can extract anything from URLs.
    Signature

    OpenXcell is rated as top Mobile App Development Company | iPhone App Development Company in India and USA.

    {{ DiscussionBoard.errors[10794056].message }}
    • Profile picture of the author Steven Roberts
      Originally Posted by Anky View Post

      You can use microsoft excel functions. Search on Google for the same.
      How you can extract anything from URLs.
      Here's a quick easy way using Excel:

      a) Paste all your URLs into Column A
      b) Select the column and click "Convert text to columns" (depends on which version of Excel you have)
      c) use the "Delimited" radio button option and click next
      d) Choose the "Other" delimiter character and enter "/"; click next and finish

      Excel will separate out the string in each cell delimited by the / character, and you'll end up with a column of all the Amazon product codes.

      There are formulae to do this as well, but this is the easiest IMO.

      Good luck
      Signature
      FREE TOOLS AND DOWNLOADS for Low Content and KDP Publishers https://istack.link
      {{ DiscussionBoard.errors[10794119].message }}
  • Profile picture of the author DIABL0
    I would hire a programmer and have them create a custom program.

    What you are wanting would be very quick and easy to create and cheap.

    However, what you may want to be thinking about is...can you automate the entire process of what you are doing. In that you are obviously finding these url's by doing some task. So could the task that you are doing to find the url's be automated.

    Then you could automate finding the url's and stripping the specific string from then. This would reduce your work load even greater.
    Signature
    How to Build LARGE EMAIL LISTS on a Budget and MONETIZE Like a PRO
    20+ Years Exp . . . . . . . . . . . . Email - CPA - PPL
    {{ DiscussionBoard.errors[10794116].message }}
  • Profile picture of the author skymann
    Paste the string into a spreadsheet (Excel or Open Office) and use a formula to extract characters from the string.

    Example: =RIGHT (text, [num_chars])
    Signature
    Top Five FREE Traffic Sources
    Click HERE to get this FREE software
    {{ DiscussionBoard.errors[10794256].message }}
  • Profile picture of the author bobby_shahzad
    For this purpose you will need to create a BOT.

    UBotstudio lets you create custom bots that can do lot of manual work for you

    Or you can find lot of bot makers there
    Signature
    BulkResponse.com Email marketing service , single and double optin accounts. List Hygiene Service Available.
    {{ DiscussionBoard.errors[10794262].message }}
  • Profile picture of the author JeffNormand
    Hmm. Looks to me that you are trying to extract the ASIN out of an Amazon URL. Right?

    Maybe if you tell us a bit more about what you do with it, I could recommend a few things.
    Signature
    {{ DiscussionBoard.errors[10794642].message }}
  • Profile picture of the author Kurt
    Go to Text Mechanic "Add line breaks":
    Add/Remove Line Breaks – TextMechanic

    Paste in your list of URLs.

    Add line break after:
    product/

    Add line break before:
    /ref=

    Copy all the text and go here and paste the text:
    Remove Lines Containing… – TextMechanic

    Then remove lines containing:
    product/

    Then remove lines containing:
    /ref=
    Signature
    Discover the fastest and easiest ways to create your own valuable products.
    Tons of FREE Public Domain content you can use to make your own content, PLR, digital and POD products.
    {{ DiscussionBoard.errors[10794724].message }}
  • Profile picture of the author aesoft
    Originally Posted by freeabs View Post

    Hi,

    Is there a software or a method that I can extract certain info from a URL easily?

    For example in this URL, hxxps://www.amazon.com/gp/product/B0154N44QS/ref=s9_cartx_gw_g421_i2_r?ie=UTF8&fpl=fresh&pf_rd_ m=ATVPDKIKX0DER&pf_rd_s=&pf_rd_r=3CEJ2SA91XEEGWS3J 0EQ&pf_rd_t=36701&pf_rd_p=a0732ba3-2c28-420f-893e-6aca94d77e48&pf_rd_i=desktop

    I want to extract only the portion between.... /product/B0154N44QS/ref=s9, meaning I only need the number B0154N44QS

    Right now I am doing it manually. Is there a method, script, website where I can easily extract the info I want as shown above? The before and after parameters are always the same.
    Hey there. I've put a little php script together for you as an example. Should accomplish what you're trying to do: [PHP] ASIN Number Extracting Example - Pastebin.com
    {{ DiscussionBoard.errors[10796363].message }}

Trending Topics