Loading ...
Sorry, an error occurred while loading the content.
 

Re: [NTB] Extracting URL from a link

Expand Messages
  • Marcelo Bastos
    ... Well, since this is the Notetab list, first step is getting your data in text-file form. Notetab does not understand the file formats used by spreadsheet
    Message 1 of 3 , Apr 10, 2013
      Interviewed by CNN on 10/04/2013 19:50, Robin Chapple told the world:
      > I have a spreadsheet with links. I need to separate the URL frown the
      > label text.
      >
      > Hoe do I do that?
      >
      >
      Well, since this is the Notetab list, first step is getting your data in
      text-file form. Notetab does not understand the file formats used by
      spreadsheet programs. You may try saving the spreadsheet as CSV or HTML,
      for instance. Then post a SMALL sample of the file content.

      I think it should be possible to extract the URLs to a file using
      regular expressions, possibly in a clip to automate the boring steps.

      --
      MCBastos

      This message has been protected with the 2ROT13 algorithm. Unauthorized use will be prosecuted under the DMCA.
      -=-=-
      ... Sent from my Mont Blanc.
      * Added by TagZilla 0.7a1 running on Seamonkey 2.17 *
      Get it at http://xsidebar.mozdev.org/modifiedmailnews.html#tagzilla
    • Robin Chapple
      Thanks Marcelo, I have managed using regular expressions and a little manual adjustment. Robin
      Message 2 of 3 , Apr 10, 2013
        Thanks Marcelo,

        I have managed using regular expressions and a little manual adjustment.

        Robin


        At 11/04/2013 09:01 AM, you wrote:
        >
        >
        >Interviewed by CNN on 10/04/2013 19:50, Robin Chapple told the world:
        > > I have a spreadsheet with links. I need to separate the URL frown the
        > > label text.
        > >
        > > Hoe do I do that?
        > >
        > >
        >Well, since this is the Notetab list, first step is getting your data in
        >text-file form. Notetab does not understand the file formats used by
        >spreadsheet programs. You may try saving the spreadsheet as CSV or HTML,
        >for instance. Then post a SMALL sample of the file content.
        >
        >I think it should be possible to extract the URLs to a file using
        >regular expressions, possibly in a clip to automate the boring steps.
        >
        >--
        >MCBastos
        >
        >This message has been protected with the 2ROT13
        >algorithm. Unauthorized use will be prosecuted under the DMCA.
        >-=-=-
        >... Sent from my Mont Blanc.
        >* Added by TagZilla 0.7a1 running on Seamonkey 2.17 *
        >Get it at
        ><http://xsidebar.mozdev.org/modifiedmailnews.html#tagzilla>http://xsidebar.mozdev.org/modifiedmailnews.html#tagzilla
        >
        >
      Your message has been successfully submitted and would be delivered to recipients shortly.