Need Script to retrieve article URLs

by 7 replies
8
I have a list of 405 article directories where a spun article was sent and
the URL of each article. I want to send 100 URLs to PingDevice and then list 100 each in Create Your Free Hosted RSS Feed In Seconds , but how do I separate the article URLS from the data in the list?

Here is an example:
www.ArticleMakt.com, GDIFast Track Team Knows Over 35 Programs to ProduceSales with Global Domains International , Approved ,

(the first 4 letters taken off so as not to show a URL)
://www.ArticleMakt.com/Art/28469/27/GDI-Fast-Track-Team-Knows-Over-35-Programs-to-ProduceSales-with-Global-Domains-International.html
#programming #article #retrieve #script #urls
  • If it wasn't for the final comma it looks like your list is a CSV file, is that true? If so there may be a way of segregating the URL into one column.

    Otherwise all I can think of is (a) a custom script or (b) a text editor with a macro. For the latter it might be useful to save the list in an e-mail or HTML editor to automatically create hyperlinks for each URL. These links would server as useful markers for a script or macro.

    Bill
    • [ 1 ] Thanks
  • Thank you mywebworker. Yes, they are a csv file and what I will try to do and you made me think ofit by reminding me it was a CSV file (I used to write C,C++ and JavaScript in my programming days), is to load all of them into an OpenOffice.org excel file. I sort of forget how to do that, but I am sure I can query hte Help file on OpenOffice.org and then I will just paste and copy the last column 100 lines down at a time and use those to input to the PingDevice.com file.
    Thanks for reminding me about CSV files.
  • If it is a CSV then it is a native file format to both Open Office and MS Office, so that should do the trick for you.

    Best of luck with it!

    Bill
    • [1] reply
    • What I did was to click on Insert, then Sheet from File and import
      the file the distribution site had emailed me. But data is filed in Rows,
      but not by columns so I have
      1.
      2. Directory Name,Title,Status,URL
      3. Directory Name,Title,Status,URL

      None of these are separated by the column lines. However, I did find
      this as refernce for someone:
      Show FORMULA or FORMAT of another cell

      I did not see anything in there to help me out, but do you have some suggestions?
  • Try renaming the file with a ".csv" extension and see if you can open it directly with Excel. This should keep everything in its own column.

    Bill
  • I am using OpenOffice but I will try doing that now.
    • [1] reply
    • I saved the file as .csv and the bar for columns magically appeared in OpenOffice after I clicked Sheet from File and then imported.
      I then copied the first 100 articles,pasted them into PingDevice,
      then while they were processing I opened Create Your Free Hosted RSS Feed In Seconds
      and created a feed for the first 100 articles. Now I will set up
      Web Traffic Genius on one of my blogs and submit those to all the major
      RSS integration sites.
Join the discussion

Next Topics on Trending Feed

  • 8

    Need Script to retrieve article URLs

    I have a list of 405 article directories where a spun article was sent and the URL of each article. I want to send 100 URLs to PingDevice and then list 100 each in Create Your Free Hosted RSS Feed In Seconds , but how do I separate the article URLS from the data in the list?