Total Dweebster

[texasoil]

Hi Stephen,

I went to your forum this morning to join... its a matter of "life or death", as in -- the death of my job! I hope this is the right area but something tells me its not...

HOWEVER - at the risk of being flamed and lambasted to a nice charcoal black.. here goes...

I need to convert filemaker 5 pro records of domains into a html output that puts the domains on the webpage as links, but also keeping them as simple listings in the db file.

Like so:

THISDOMAIN.COM - (this is the way the domain field text is entered and listed in the database - it has to be viewable in this format)

I need it to be outputted into another field for exporting as html so that it looks like this:

<a href="http://www.THISDOMAIN.COM">THISDOMAIN.COM</a><br>

This way our company's huge list of domains can be immediately formatted for appearance on a webpage without showing the "http://www." part. The html code above will make the domain appear as a link WITHOUT the html code. In other words, the domain name has to appear as a link on the webpage as just the domain name only.... "THISDOMAIN.COM" - and its a link.

Formatting each domain by hand in the company's portfolio is a humungous job because there are thousands...

I have no idea how to take a field entry, such as "THISDOMAIN.COM", and mesh it together to appear TWICE in another field with text before, inbetween, and after!! What a nightmare. My boss EXPECTS me to know this -- I can't find the info anywhere in the manual.

So the one field "DOMAIN NAME" holds this text = "THISDOMAIN.COM". Then it has to appear in another field, let's call it "HTML EXPORT" like this (I'll separate the html areas before, middle, and after the domain name)

BEFORE = <a href="http://www. MIDDLE = "> AFTER = </a><br>

which combines the text in the domain name field "THISDOMAIN.COM" in this html coding into another field that I can export and upload to a webpage:

<a href="http://www.THISDOMAIN.COM">THISDOMAIN.COM</a><br>

hope that makes sense!!!

If you could help me, I'd be grateful!! Blessings upon you!!!

Thanks!

Stephen

NO COMPANY NAME !!!

[H.P.]

I don't know about filemaker 5 so I cannot give you specific answer. Perhaps someone else can provide more detail intructions. (In FM7, you can use calculation fields to format it... I bet it's pretty easy to do in FM5 too)

As a work around, you can use the following appoach, it is very easy to follow and take less than 5 mins, no programming necessary except some excel formulas:

Export the filemaker 5 records to a text file (separated by comma, tab, carriage, or whatever....) so it will be listed as: domain1.com, domain2.com or

domain1.com domain2.com, or,

domain1.com

domain2.com

Then, open excel (assumming you have excel on your comp), click on tool menu->data->get external data->import text file

Then select your file (click on all file to view all files), select the right data type and follow the instruction.... It will import all the records in Excel

Then use excel formula to format it in this format:

<a href="http://www.THISDOMAIN.COM">THISDOMAIN.COM</a><br>

Then copy and paste all the cells to notepad.. add some more html code on top and you will have an html page

[-Queue-]

You can create a calculation text field in 5 of

"<a href=""http://www." & DOMAINNAME & """>" & DOMAINNAME & "</a><br>"