This is an archived, read-only copy of the United-TI subforum , including posts and topic from May 2003 to April 2012. If you would like to discuss any of the topics in this forum, you can visit Cemetech's Calculator Programming subforum. Some of these topics may also be directly-linked to active Cemetech topics. If you are a Cemetech member with a linked United-TI account, you can link United-TI topics here with your current Cemetech topics.

This forum is locked: you cannot post, reply to, or edit topics. General Coding and Design => Calculator Programming
Author Message
Galandros


Active Member


Joined: 29 Aug 2008
Posts: 565

Posted: 14 Jan 2009 04:59:18 pm    Post subject:

I think this section serve.

I goggled and no good results so I turn to you.
I want a script/program/macros or anything to help me out doing a tedious work:

From a text file like this:
Quote:

Transform into a html code like this:
Quote:
<a href="http://www.ticalc.org/">http://www.ticalc.org/</a>
<a href="http://www.calc.org/">http://www.calc.org/</a>
<a href="http://www.unitedti.org/">http://www.unitedti.org/</a>

and if possible another version that outputs:
Quote:
<a href="http://www.ticalc.org/"></a>
<a href="http://www.calc.org/"></a>
<a href="http://www.unitedti.org/"></a>


I think the examples are self explanatory. If you can make the program ignore lines without links, then perfect. I want the two versions because I am not sure if I want to post the site or some text instead.
EDIT: maybe I have some links ended in index.html,.php or that sort of things.

The reason for this is I am writing my site to TI-Community and I have a text file full of links that I want to share. If anyone knows a good templates/themes to inspire me, would be fantastic.
I know tifreakware has links but mine has other sites.

Thanks in advance.
PS: Oh and you receive a nice credit in my site of course.


Last edited by Guest on 14 Jan 2009 05:02:56 pm; edited 1 time in total
Back to top
arjan


Newbie


Joined: 14 Jan 2009
Posts: 3

Posted: 14 Jan 2009 05:13:01 pm    Post subject:

I found http://www.liamdelahunty.com/tips/php_conv...url_to_link.php

But I don't know if you use php
Back to top
benryves


Active Member


Joined: 23 Feb 2006
Posts: 564

Posted: 14 Jan 2009 05:27:30 pm    Post subject:

Excel is surprisingly good at this. Copy the plain text links into the column A. Move into cell B1 and enter the formula

Code:
=IF(A1<>"","<a href=""" & A1 & """>" & A1 & "</a>","")


Now double-click the handle in the bottom-left of B1's cell selection rectangle (or drag it downwards). Click B's column header, copy and paste from Excel into another text file, and Robert's your father's brother.


Last edited by Guest on 14 Jan 2009 05:29:12 pm; edited 1 time in total
Back to top
Galandros


Active Member


Joined: 29 Aug 2008
Posts: 565

Posted: 15 Jan 2009 07:19:35 am    Post subject:

benryves wrote:
Excel is surprisingly good at this. Copy the plain text links into the column A. Move into cell B1 and enter the formula

Code:
=IF(A1<>"","<a href=""" & A1 & """>" & A1 & "</a>","")


Now double-click the handle in the bottom-left of B1's cell selection rectangle (or drag it downwards). Click B's column header, copy and paste from Excel into another text file, and Robert's your father's brother.
Oh, well I... know Excel. Problem solved.
Back to top
Display posts from previous:   
Register to Join the Conversation
Have your own thoughts to add to this or any other topic? Want to ask a question, offer a suggestion, share your own programs and projects, upload a file to the file archives, get help with calculator and computer programming, or simply chat with like-minded coders and tech and calculator enthusiasts via the site-wide AJAX SAX widget? Registration for a free Cemetech account only takes a minute.

» Go to Registration page
    »
» View previous topic :: View next topic  
Page 1 of 1 » All times are UTC - 5 Hours

 

Advertisement