Bruce, if you clicked it, the link carried over an * from the original email. http://tableizer.journalistopia.com/ On Mon, Jul 15, 2013 at 12:37 PM, Bruce Coyne <ElmFlats@aim.com> wrote: > The website mentioned is not active. > > On 7/14/2013 9:36 AM, GWS wrote: > > "I have a spread sheet of Rev War Burials and would like to post this > > information on my rootsweb homepage. If I cut the spread sheet to only > > the data I wish to post it would be 200 rows and six columns.*Any > > suggestions on the easiest way to code this for a rootsweb page?* > .........." > > > > This site will create an html page of any Excel, Calc, etc. spreadsheet: > > *http://tableizer.journalistopia.com/* > > Copy your data from the spreadsheet and past into the box on their page, > > then copy the results > > to your html editor and edit/add whatever you want added. > > > > This one converts Word to clean html: *http://word2cleanhtml.com/* > > If you like really clean, and simple, this one is for you. > > >

Bruce, Both links have an extraneous quotation mark at the end of the links in the email. Just remove those, i.e. <http://tableizer.journalistopia.com/> and <http://word2cleanhtml.com/> Pat A. At 12:37 PM 7/15/2013, Bruce Coyne wrote: >The website mentioned is not active. > >On 7/14/2013 9:36 AM, GWS wrote: > > "I have a spread sheet of Rev War Burials and would like to post this > > information on my rootsweb homepage. If I cut the spread sheet to only > > the data I wish to post it would be 200 rows and six columns.*Any > > suggestions on the easiest way to code this for a rootsweb > page?* .........." > > > > This site will create an html page of any Excel, Calc, etc. spreadsheet: > > *http://tableizer.journalistopia.com/* > > Copy your data from the spreadsheet and past into the box on their page, > > then copy the results > > to your html editor and edit/add whatever you want added. > > > > This one converts Word to clean html: *http://word2cleanhtml.com/* > > If you like really clean, and simple, this one is for you. > > > > > > > > > > >------------------------------- >To unsubscribe from the list, please send an email to >FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' >without the quotes in the subject and the body of the message

The website mentioned is not active. On 7/14/2013 9:36 AM, GWS wrote: > "I have a spread sheet of Rev War Burials and would like to post this > information on my rootsweb homepage. If I cut the spread sheet to only > the data I wish to post it would be 200 rows and six columns.*Any > suggestions on the easiest way to code this for a rootsweb page?* .........." > > This site will create an html page of any Excel, Calc, etc. spreadsheet: > *http://tableizer.journalistopia.com/* > Copy your data from the spreadsheet and past into the box on their page, > then copy the results > to your html editor and edit/add whatever you want added. > > This one converts Word to clean html: *http://word2cleanhtml.com/* > If you like really clean, and simple, this one is for you. > > > >

Thanks for the reply. I'll give it a try and see how I do. The code produced is for what, a table, a list? Bruce On 7/14/2013 6:52 AM, Nick Reddan wrote: > Bruce > > Starting with the spreadsheet it is relatively easy to get the html code > into notepad. > > Notepad is a perfectly acceptable editor for HTML file (I tend to use > Wordpad but the differences betwen them in dealing with text files is > miniscule. > > The worksheets in my file: > http://members.iinet.net.au/~nickred/temp/little_table.htm > have 4 columns and ten rows of data. To make them work for 6 columns > you need to insert two columns after column L and two columns after E. > Then copy the formula in column E to the next two columns. Then copy the > formula in column N to the next two columns.Change the formula in column > P row 8 to: > ="<tr>"&I8&J8&K8&L8&M8&N8&O8&"</tr>" > > Insert as many rows as needed after row 18 and copy down the formula. > > Paste your data into cells B9 to the end. > > Copying the cells in columns P to Notepad will yield the appropriate code. > > If you have difficulties in following the instruction above send the > spreadsheet you have and I will put the conversion formula into it and > then you can copy the resulting code into Notepad and spit out the > required html. > > > Regards > > > Nick > > > My Sites > My home <http://members.iinet.net.au/%7Enickred/> > My newspaper extracts > <http://members.iinet.net.au/%7Enickred/newspaper/index.html> > Registry of Deeds Index Project > <http://freepages.genealogy.rootsweb.com/%7Eregistryofdeeds/index.html> > > > Managed Sites > Irish Genealogical Research Society > <http://www.igrsoc.org/index.htm> > Majura tennis Club > <http://members.iinet.net.au/%7Enickred/majuratennis/> > > On 14/07/2013 5:00 PM, freepages-help-request@rootsweb.com wrote: >> Message: 3 >> Date: Sat, 13 Jul 2013 07:30:21 -0400 >> From: Bruce Coyne<ElmFlats@aim.com> >> Subject: [FreeHelp] Table on rootsweb >> To:FREEPAGES-HELP@rootsweb.com >> Message-ID:<51E13A4D.5050700@aim.com> >> Content-Type: text/plain; charset=ISO-8859-1; format=flowed >> >> I have a spread sheet of Rev War Burials and would like to post this >> information on my rootsweb homepage. If I cut the spread sheet to only >> the data I wish to post it would be 200 rows and six columns. Any >> suggestions on the easiest way to code this for a rootsweb page? I've >> written the code for all my pages with notepad++. > > ------------------------------- > To unsubscribe from the list, please send an email to FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Bruce Starting with the spreadsheet it is relatively easy to get the html code into notepad. Notepad is a perfectly acceptable editor for HTML file (I tend to use Wordpad but the differences betwen them in dealing with text files is miniscule. The worksheets in my file: http://members.iinet.net.au/~nickred/temp/little_table.htm have 4 columns and ten rows of data. To make them work for 6 columns you need to insert two columns after column L and two columns after E. Then copy the formula in column E to the next two columns. Then copy the formula in column N to the next two columns.Change the formula in column P row 8 to: ="<tr>"&I8&J8&K8&L8&M8&N8&O8&"</tr>" Insert as many rows as needed after row 18 and copy down the formula. Paste your data into cells B9 to the end. Copying the cells in columns P to Notepad will yield the appropriate code. If you have difficulties in following the instruction above send the spreadsheet you have and I will put the conversion formula into it and then you can copy the resulting code into Notepad and spit out the required html. Regards Nick My Sites My home <http://members.iinet.net.au/%7Enickred/> My newspaper extracts <http://members.iinet.net.au/%7Enickred/newspaper/index.html> Registry of Deeds Index Project <http://freepages.genealogy.rootsweb.com/%7Eregistryofdeeds/index.html> Managed Sites Irish Genealogical Research Society <http://www.igrsoc.org/index.htm> Majura tennis Club <http://members.iinet.net.au/%7Enickred/majuratennis/> On 14/07/2013 5:00 PM, freepages-help-request@rootsweb.com wrote: > Message: 3 > Date: Sat, 13 Jul 2013 07:30:21 -0400 > From: Bruce Coyne<ElmFlats@aim.com> > Subject: [FreeHelp] Table on rootsweb > To:FREEPAGES-HELP@rootsweb.com > Message-ID:<51E13A4D.5050700@aim.com> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > I have a spread sheet of Rev War Burials and would like to post this > information on my rootsweb homepage. If I cut the spread sheet to only > the data I wish to post it would be 200 rows and six columns. Any > suggestions on the easiest way to code this for a rootsweb page? I've > written the code for all my pages with notepad++.

Continuing on:- Having created and saved "yourfilename.csv" using your Text Editor, it is now time to get this data into a Spreadsheet. I suspect that many Windows PC owners will have available MS Excel, and those who dont can download the Apache Open Office software. Another option is to use the Google online Spreadsheet. I have been using Open Office "Calc" and saving my work in the MS .xls/.xlsx format and have also checked the Linux/Ubuntu LibreOffice Calc. A test of a Google Docs spreadsheet proved that it was also useable, though a little slower to use than the dedicated local software. There is also a small learning curve when using the online spreadsheet as some of the methods used in the local software are different online. For instance, the Copy & Fill Down method is not available, so click on the cell to be copied, then Ctrl+C and 'shift' and 'down arrow"' to highlight to the lower cell, followed by Ctrl+V - achieves the same outcome. I'm going to demonstrate two different methods of effectively achieving the same out come; (1) In Windows Explorer navigate to "yourfilename.csv" - in my case the file is "data-table-class.csv" and double click on it. It should open the default spreadsheet program and show you the Import options box. In the Separated options area ensure that the only box checked is that marked "other" and key in the | pipe character into the associated input field. If all is going well you will see part of the data showing in some ordered semblance in the bottom field. (2) Click OK and the spreadsheet will open showing data in Columns A through F and Rows 1 to 5. (a) Download and Save - http://freepages.rootsweb.com/~bristowe/test/table/data-table-class.xls (b) Navigate to and Open the downloaded file in your default Spreadsheet. (c) Another Spreadsheet will open, and you are going to insert the data from the .csv file in it. (3) Click on the Spreadsheet that loaded the .csv file and highlight and Ctrl+C the contents mentioned in (2). (a) Go back to the other Spreadsheet and load the copied data in at Column A Row 16. (b) The cells to the right will show signs of having picked up that data. (4) Highlight all the data in Column P down to Row 24 and to the right. (a) Ctrl+C then open a new Text Editor page and, (b) Paste Ctrl+V the data into it and save a "yourfilename.html". (c) You now have a working page to open in your browser. That completes the first method, and you can tidy up the page by changing the cells in the top row to show the missing headings, e.g. <tr><th class='name'>Name</th><th>Grave No.</th> .. etc.. </tr> The second method is quite simple:- (5) Carry out operation described in (2), (a) Click on Column A and go to Insert > Column, and do the same for the other columns holding data. (b) In Column B Row 1 add <tr><td>; Columns D, F, I and K add </td><td>; in Column M add </td></tr> (c) Copy the code in each new column in Row 1 down to including Row 5, then Highlight, Copy & Paste into an new page in your Text Editor and Save. (d) Clean up any extra spaces in the table with the Search & Replace function, (e) Add the heading cells mentioned above, and lastly make sure that <table> and </table> tags are inserted. (6) A simple method of providing initial styles (as there are no class names), is to copy the following into the head of the page:- <style> table {border-collapse:collapse;border-spacing:0;text-align:center} table th, table td {border:solid 1px #aaa;padding:2px 3px} table th:nth-child(odd), table td:nth-child(odd) {text-align:left} </style> Those styles will work in all browsers back to and including Internet Explorer 7. Barry

I suspected so, which is why I pointed out no link on the words DNA testing. Here is a help page about how to remove that browser highjacker. http://botcrawl.com/how-to-remove-coupondropdown-adware-and-uninstall-the-coupondropdown-extension/ Third party programs that bundle often download these things. Example: MP3 Rocket forced Ask (dot com) toolbar onto my PC even though I unchecked the box, and bought with it a Couponer thingie on Ask toolbar. I was SO ticked (no pun intended lol). Confused though... if none of us could see the link...if no public can see it, what is the purpose of the downloader-- other than to aggravate you, the PC-owner? Judy On Sun, Jul 14, 2013 at 1:00 AM, PAUL SHEATS Owner <paul.sheats@q.com>wrote: > Thanks all, I think I figured out what is going on. I was not talking > about the link on the word "here", I was talking about the link on the > words "DNA testing". If I hover my cursor over these words, it says "Click > to Continue > by CouponDropDown". No looking how to remove this adware. > > Thanks. > Paul > > >

At 01:00 AM 7/14/2013, you wrote: >Thanks all, I think I figured out what is going on. I was not >talking about the link on the word "here", I was talking about the >link on the words "DNA testing". If I hover my cursor over these >words, it says "Click to Continue > by CouponDropDown". No looking >how to remove this adware. When I had that problem, I found it was caused by one of my Firefox addins. Once I removed it, the problem went away. I believe it was SEO Doctor but not sure. pat

"I have a spread sheet of Rev War Burials and would like to post this information on my rootsweb homepage. If I cut the spread sheet to only the data I wish to post it would be 200 rows and six columns.*Any suggestions on the easiest way to code this for a rootsweb page?* .........." This site will create an html page of any Excel, Calc, etc. spreadsheet: *http://tableizer.journalistopia.com/* Copy your data from the spreadsheet and past into the box on their page, then copy the results to your html editor and edit/add whatever you want added. This one converts Word to clean html: *http://word2cleanhtml.com/* If you like really clean, and simple, this one is for you. On 7/14/13 2:00, freepages-help-request@rootsweb.com wrote: > > When replying to a digest message, quote only the specific message to which you are replying, removing the rest of the digest from your reply. Remember to change the subject of your reply so that it coincides with the message subject to which you are replying. > ***FREEPAGES HELP & FAQ*** > &lt;http://helpdesk.rootsweb.com/FAQ/fpindex.html> > > > Today's Topics: > > 1. Re: FREEPAGES-HELP Digest, Vol 8, Issue 94 (Nick Reddan) > 2. Re: FREEPAGES-HELP Digest, Vol 8, Issue 94 (Jill Muir) > 3. Table on rootsweb (Bruce Coyne) > 4. Converting word tables into FP (Valerie lirakis) > 5. Re: Extract Table Data & Convert to useable HTML (Billie Walsh) > 6. Re: FREEPAGES-HELP Digest, Vol 8, Issue 94 (JFlorian) > 7. Re: Converting word tables into FP (JFlorian) > 8. Re: Links I did not create (PAUL SHEATS Owner) > 9. Re: Extract Table Data & Convert to useable HTML (Barry Carlson) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 13 Jul 2013 17:01:25 +1000 > From: Nick Reddan <nickred@webone.com.au> > Subject: Re: [FreeHelp] FREEPAGES-HELP Digest, Vol 8, Issue 94 > To: freepages-help@rootsweb.com > Message-ID: <51E0FB45.3080107@webone.com.au> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Judy > > When I did this originally, some time ago, I posted the following link: > http://members.iinet.net.au/~nickred/temp/little_table.htm > > It shows the basic concept which can be tarted up with a bit of CSS to > make it 'pretty'. > > The page: > http://freepages.genealogy.rootsweb.ancestry.com/~registryofdeeds/contributors/contributor_index.htm > The table and all the graphics are produced by a spreadsheet macro. > > At the very simple level all spreadsheets are essentially the same, but > differences appear when you get to macros and automation. > > I have not used the Google spreadsheet. > > > Regards > > > Nick > > > My Sites > My home <http://members.iinet.net.au/%7Enickred/> > My newspaper extracts > <http://members.iinet.net.au/%7Enickred/newspaper/index.html> > Registry of Deeds Index Project > <http://freepages.genealogy.rootsweb.com/%7Eregistryofdeeds/index.html> > > > Managed Sites > Irish Genealogical Research Society > <http://www.igrsoc.org/index.htm> > Majura tennis Club > <http://members.iinet.net.au/%7Enickred/majuratennis/> > > On 13/07/2013 4:12 PM, freepages-help-request@rootsweb.com wrote: >> Hi Nick, >> >> There are many people who don't have Excel or Office Suite, or know how to >> use Excel. I'll be hand-numbering until I get a gift of the program. >> >> Judy > > > ------------------------------ > > Message: 2 > Date: Sat, 13 Jul 2013 09:58:34 +0100 > From: "Jill Muir" <jill@shottle.plus.com> > Subject: Re: [FreeHelp] FREEPAGES-HELP Digest, Vol 8, Issue 94 > To: <freepages-help@rootsweb.com> > Message-ID: <07DA6B31ADD443D28FAD0EC612D61D8B@JILLMUIR> > Content-Type: text/plain; charset="us-ascii" > > Just checked with WC3 Nick - 209 Errors, 3 warning(s) > > My best wishes, Jill > Glamorgan Mailing List's website > http://freepages.genealogy.rootsweb.ancestry.com/~glamorgan/ > > > -----Original Message----- > From: freepages-help-bounces@rootsweb.com > [mailto:freepages-help-bounces@rootsweb.com] On Behalf Of Nick Reddan > Sent: 13 July 2013 08:01 > To: freepages-help@rootsweb.com > Subject: Re: [FreeHelp] FREEPAGES-HELP Digest, Vol 8, Issue 94 > > Judy > > When I did this originally, some time ago, I posted the following link: > http://members.iinet.net.au/~nickred/temp/little_table.htm > > It shows the basic concept which can be tarted up with a bit of CSS to > make it 'pretty'. > > The page: > http://freepages.genealogy.rootsweb.ancestry.com/~registryofdeeds/contributo > rs/contributor_index.htm > The table and all the graphics are produced by a spreadsheet macro. > > At the very simple level all spreadsheets are essentially the same, but > differences appear when you get to macros and automation. > > I have not used the Google spreadsheet. > > > Regards > > > Nick > > > My Sites > My home <http://members.iinet.net.au/%7Enickred/> > My newspaper extracts > <http://members.iinet.net.au/%7Enickred/newspaper/index.html> > Registry of Deeds Index Project > > <http://freepages.genealogy.rootsweb.com/%7Eregistryofdeeds/index.html> > > > Managed Sites > Irish Genealogical Research Society > <http://www.igrsoc.org/index.htm> > Majura tennis Club > <http://members.iinet.net.au/%7Enickred/majuratennis/> > > On 13/07/2013 4:12 PM, freepages-help-request@rootsweb.com wrote: >> Hi Nick, >> >> There are many people who don't have Excel or Office Suite, or know how to >> use Excel. I'll be hand-numbering until I get a gift of the program. >> >> Judy > > ------------------------------- > To unsubscribe from the list, please send an email to > FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the > quotes in the subject and the body of the message > > > > ------------------------------ > > Message: 3 > Date: Sat, 13 Jul 2013 07:30:21 -0400 > From: Bruce Coyne <ElmFlats@aim.com> > Subject: [FreeHelp] Table on rootsweb > To: FREEPAGES-HELP@rootsweb.com > Message-ID: <51E13A4D.5050700@aim.com> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > I have a spread sheet of Rev War Burials and would like to post this > information on my rootsweb homepage. If I cut the spread sheet to only > the data I wish to post it would be 200 rows and six columns. Any > suggestions on the easiest way to code this for a rootsweb page? I've > written the code for all my pages with notepad++. >

Paul, I may have had the same type of problem on a website I have at GoDaddy.com. My site when I went to it had links I did not create.. I called tech support GoDaddy and Was told no one elde saw them. The tech said some browsers will create links when accessed by the browsers. THey had me clear my cookies and? something else and the links went away.. ?? Nelda http://www.cafepress.com/awab If you care about animals please visit our link > Date: Sun, 14 Jul 2013 01:00:24 -0400 > From: paul.sheats@q.com > To: freepages-help@rootsweb.com > Subject: Re: [FreeHelp] Links I did not create > > Thanks all, I think I figured out what is going on. I was not talking about the link on the word "here", I was talking about the link on the words "DNA testing". If I hover my cursor over these words, it says "Click to Continue > by CouponDropDown". No looking how to remove this adware. > > Thanks. > Paul > > ------------------------------- > To unsubscribe from the list, please send an email to FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Thanks all, I think I figured out what is going on. I was not talking about the link on the word "here", I was talking about the link on the words "DNA testing". If I hover my cursor over these words, it says "Click to Continue > by CouponDropDown". No looking how to remove this adware. Thanks. Paul

Okay - what is Table Data and, how do I extract it? I think it may be a help to my one name study. Thanks Gerry __________ Information from ESET Smart Security, version of virus signature database 8559 (20130712) __________ The message was checked by ESET Smart Security. http://www.eset.com

The problem of extracting table data originally produced by MS Word and auto converted to HTML has been around as long as MS Word! I have described methods to use in previous postings, but the basic problem with the HTML code that needs tidying up, is that the more sophisticated the original Word product, the greater the generated code used to represent it as a web page. In the case presented by Valerie, the effort required to clean up the data table is best done as follows:- (1) Get yourself a good "free" Text Editor, I use PSPad - http://www.pspad.com/en/download.php (2) If you dont have MS Excel, then download the "free" Apache Open Office program - http://www.openoffice.org/download/ (a) Or do it online for "free" at http://docs.google.com (i) You will need to create a Google account first. (3) Bring up this much shortened version of Valerie's Edgworth page in your "browser" - http://countjustonce.com/test/edgworth-example.html (a) Highlight and Copy the 5 rows and 6 Columns containing the table data - (b) commencing with the first name then ... (4) Open your Text Editor in a new page, (a) Paste the above data into it. (5) You are going to turn this data into a valid CSV (comma separated values) file, but in this case we are going to use the "|" pipe character instead of a "," as there are heaps of commas already delimiting numeral values in the data. (a) Carefully highlight the largest space after the first name, and (i) Select Search & Replace, and when presented with the dialogue box (ii) Paste the "space" into the Find box (iii)Enter the | character into the Replace box (iv) Check the Prompt for Each Replacement box and Click OK. (v) If happy with the first line prompted, click YES to All. (6) You will now have the | character in every space, but there may be some spaces around it. (a) Once again select a space, but this time after placing it in the Find box, (b) Ensure that the Replace box is empty. (c) Click OK and Yes to All (d) Repeat if necesary. (7) The data space will have contracted itself considerably by the time you have eliminated the spaces. (8) The data in question contains comma separated numerals, and they can often create problems when being transfered between a Text Editor and a Spreadsheet such as MS Excel or Apache Open Office "Calc". To avoid this, (a) Select a comma "," and use the Find & Replace function again, and (b) In the Replace box enter a comma followed by one space ", " (without the "quotes") (c) Click OK and Yes to All. (9) Save the file as - yourfilename.csv and the third line should look like this:- Aspden|244|Gardner|11, 209, 313|Pilkington|267 (10)Now is the time to open your Spreadsheet program - or Google Spreadsheets. Part 2 will follow tomorrow. Barry

Judy When I did this originally, some time ago, I posted the following link: http://members.iinet.net.au/~nickred/temp/little_table.htm It shows the basic concept which can be tarted up with a bit of CSS to make it 'pretty'. The page: http://freepages.genealogy.rootsweb.ancestry.com/~registryofdeeds/contributors/contributor_index.htm The table and all the graphics are produced by a spreadsheet macro. At the very simple level all spreadsheets are essentially the same, but differences appear when you get to macros and automation. I have not used the Google spreadsheet. Regards Nick My Sites My home <http://members.iinet.net.au/%7Enickred/> My newspaper extracts <http://members.iinet.net.au/%7Enickred/newspaper/index.html> Registry of Deeds Index Project <http://freepages.genealogy.rootsweb.com/%7Eregistryofdeeds/index.html> Managed Sites Irish Genealogical Research Society <http://www.igrsoc.org/index.htm> Majura tennis Club <http://members.iinet.net.au/%7Enickred/majuratennis/> On 13/07/2013 4:12 PM, freepages-help-request@rootsweb.com wrote: > Hi Nick, > > There are many people who don't have Excel or Office Suite, or know how to > use Excel. I'll be hand-numbering until I get a gift of the program. > > Judy

On Sat, Jul 13, 2013 at 7:53 AM, Valerie lirakis < valerie.lirakis@googlemail.com> wrote: <snip> Judy - after trying both ways to do this, I have to agree that your way is the best. My apologies for having doubted you! I, too, have learned my lesson which is never again do tables in MS Word. Valerie ------ Though I say thank you for your comment, I also feel 'condolences' are in order.... I remember the hours I spent on several MS Word files and their stupid tables----locating a piece of MS Code, making sure I knew the right replacement coding, and doing (what seemed like thousands) of Find-Replace. It was so boring--- mentally 'painful'. I was so relieved when I fixed the last code--- it was over. Hooray. I found it easiest while I worked if I had nearby--- 1. favorite beverage & refills 2. mini-chocolates, like peanut butter cup minis--- nothing better for "comforting foods" 3. and one of those easy to squeeze rubber balls (Koosh ball?) -- rather than punching my monitor screen! 4. I told friends/family to "Just stay away from me!!!" & "Don't talk to me!!" while I worked -- LOL 5. Put a radio on, in case you get to swearing. I never cussed so much in my life as I did about MS Word code! 6. Repeat Mantra frequently: "never use MS Word for webpages" Just know, you aren't alone... others have done what you're setting out to do. Feel free to come here to vent when you need. And.... remember, it will soon be over & done! Judy

Thanks Nick, I'll save the link. On Sat, Jul 13, 2013 at 3:01 AM, Nick Reddan <nickred@webone.com.au> wrote: > Judy > > When I did this originally, some time ago, I posted the following link: > http://members.iinet.net.au/~nickred/temp/little_table.htm > > It shows the basic concept which can be tarted up with a bit of CSS to > make it 'pretty'. > > The page: > > http://freepages.genealogy.rootsweb.ancestry.com/~registryofdeeds/contributors/contributor_index.htm > The table and all the graphics are produced by a spreadsheet macro. > > At the very simple level all spreadsheets are essentially the same, but > differences appear when you get to macros and automation. > > I have not used the Google spreadsheet. > > > Regards > > Nick > > > My Sites > My home <http://members.iinet.net.au/%7Enickred/> > My newspaper extracts > <http://members.iinet.net.au/%7Enickred/newspaper/index.html> > Registry of Deeds Index Project > < > http://freepages.genealogy.rootsweb.com/%7Eregistryofdeeds/index.html> > > > Managed Sites > Irish Genealogical Research Society > <http://www.igrsoc.org/index.htm> > Majura tennis Club > <http://members.iinet.net.au/%7Enickred/majuratennis/>

Many thanks to all those who have again taken the time and trouble to reply to my query. Judy - after trying both ways to do this, I have to agree that your way is the best. My apologies for having doubted you! I, too, have learned my lesson which is never again do tables in MS Word. Valerie

Paul, I very much doubt that your page has mysteriously been intercepted and modified. When I saw your original post, I like others who have posted, examined the code around the link and found it had been generated in MSO. That is not the signature you'd expect to see when some hacker is inserting code. Have you checked the date and time your file was last modified on your computer and the website? Barry On Sat, 13 Jul 2013 10:35:54 +1200, PAUL SHEATS Owner <paul.sheats@q.com> wrote: > I'm now wondering if it could have been CenturyLink, my internet > provider, that added the link? I have seen before where CenturyLink > would add a link to a date or some other information in my email. God, > I hate CenturyLink. > > Paul > > > > > ------------------------------ > > Message: 7 > Date: Thu, 11 Jul 2013 21:27:50 -0400 > From: JFlorian <cageycat@gmail.com> > Subject: Re: [FreeHelp] Links I did not create > To: freepages-help@rootsweb.com > Message-ID: > <CAE5hz-CJkYapmj7teSO5+UQf_OzPQ=oWa3ytXU0j8T-NCEFfLQ@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Unless I misunderstood your question, I disagree that Ancestry inserted > the > link. > > First, Ancestry would keep their inserted data with their banner. None > of > my freepages have a link inserted by ancestry, except the banner. > > The line is *Click > **here*<http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20dna%20project%20-%20hot%20deals.htm> > * to see current special deals on DNA testing! -- The link is on the > word > "here". **There is NO link on the words "DNA Testing".* > * > * > Second, if you View Source, the link was inserted in MS Word starting > here > (minus the dots): > <....p class=MsoNormal><....b style='mso-bidi-font-weight:normal'><span > style='font-family:"Verdana","sans-serif";mso-bidi-font-family:Arial; > color:red'>Click </span></b><a > href=" > http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20dna%20project%20-%20hot%20deals.htm > "><b > style='mso-bidi-font-weight:normal'><span > style='font-family:"Verdana","sans-serif"; > mso-bidi-font-family:Arial;color:red'>here</span></b></a><b > style='mso-bidi-font-weight: > normal'><span > style='font-family:"Verdana","sans-serif";mso-bidi-font-family: > Arial;color:red'> to see current special deals on DNA > testing!<o:p></o:p></span></b></p> > > The link goes to here on your site: > http://freepages.genealogy.rootsweb.ancestry.com/~sheetsdna/sheets%20dna%20project%20-%20hot%20deals.htm > > Those percent 20 in your file name reflects a space between words. It > makes > shorter links if you use underscore or hyphen between words. > > Judy > > On Thu, Jul 11, 2013 at 8:33 PM, PAUL SHEATS Owner > <paul.sheats@q.com>wrote: > > ------------------------------- > To unsubscribe from the list, please send an email to > FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without > the quotes in the subject and the body of the message

Just checked with WC3 Nick - 209 Errors, 3 warning(s) My best wishes, Jill Glamorgan Mailing List's website http://freepages.genealogy.rootsweb.ancestry.com/~glamorgan/ -----Original Message----- From: freepages-help-bounces@rootsweb.com [mailto:freepages-help-bounces@rootsweb.com] On Behalf Of Nick Reddan Sent: 13 July 2013 08:01 To: freepages-help@rootsweb.com Subject: Re: [FreeHelp] FREEPAGES-HELP Digest, Vol 8, Issue 94 Judy When I did this originally, some time ago, I posted the following link: http://members.iinet.net.au/~nickred/temp/little_table.htm It shows the basic concept which can be tarted up with a bit of CSS to make it 'pretty'. The page: http://freepages.genealogy.rootsweb.ancestry.com/~registryofdeeds/contributo rs/contributor_index.htm The table and all the graphics are produced by a spreadsheet macro. At the very simple level all spreadsheets are essentially the same, but differences appear when you get to macros and automation. I have not used the Google spreadsheet. Regards Nick My Sites My home <http://members.iinet.net.au/%7Enickred/> My newspaper extracts <http://members.iinet.net.au/%7Enickred/newspaper/index.html> Registry of Deeds Index Project <http://freepages.genealogy.rootsweb.com/%7Eregistryofdeeds/index.html> Managed Sites Irish Genealogical Research Society <http://www.igrsoc.org/index.htm> Majura tennis Club <http://members.iinet.net.au/%7Enickred/majuratennis/> On 13/07/2013 4:12 PM, freepages-help-request@rootsweb.com wrote: > Hi Nick, > > There are many people who don't have Excel or Office Suite, or know how to > use Excel. I'll be hand-numbering until I get a gift of the program. > > Judy ------------------------------- To unsubscribe from the list, please send an email to FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

I use Libre Office, as I have said before, and I use it to create long tables quite often. It does a reasonable job of saving as HTML but it still adds a fair amount of extraneous baggage to the page. The way I deal with it is to open the converted HTML in my web page editor, Bluefish, and use the "Replace" function, <Control>+<R>. Highlight the tag, or part of the tag, I want gone , <Control>+<R>, leave the "Replace With" blank and click "Replace All". Every instance of that tag, or portion thereof, on the page is gone. I took the source of the small bit of table that Barry posted and in less than five minutes had it stripped out to basic HTML. OK, I will admit that I am no novice to HTML. I've never in my life used a WYSIWYG editor. I learned to make pages back in the dark ages when there were, I think, maybe about twenty tags and their modifiers. There was no such thing as a WYSIWYG editor back then. I only create tables in a spreadsheet program because it's simpler than coding on the fly as you enter data. On 07/13/2013 01:12 AM, Barry Carlson wrote: > The problem of extracting table data originally produced by MS Word and > auto converted to HTML has been around as long as MS Word! > > I have described methods to use in previous postings, but the basic > problem with the HTML code that needs tidying up, is that the more > sophisticated the original Word product, the greater the generated code > used to represent it as a web page. > > In the case presented by Valerie, the effort required to clean up the data > table is best done as follows:- > > (1) Get yourself a good "free" Text Editor, I use PSPad - > http://www.pspad.com/en/download.php > (2) If you dont have MS Excel, then download the "free" Apache Open Office > program - > http://www.openoffice.org/download/ > (a) Or do it online for "free" at http://docs.google.com > (i) You will need to create a Google account first. > (3) Bring up this much shortened version of Valerie's Edgworth page in > your "browser" - > http://countjustonce.com/test/edgworth-example.html > (a) Highlight and Copy the 5 rows and 6 Columns containing the table > data - > (b) commencing with the first name then ... > (4) Open your Text Editor in a new page, > (a) Paste the above data into it. > (5) You are going to turn this data into a valid CSV (comma separated > values) file, but in this case we are going to use the "|" pipe character > instead of a "," as there are heaps of commas already delimiting numeral > values in the data. > (a) Carefully highlight the largest space after the first name, and > (i) Select Search & Replace, and when presented with the dialogue > box > (ii) Paste the "space" into the Find box > (iii)Enter the | character into the Replace box > (iv) Check the Prompt for Each Replacement box and Click OK. > (v) If happy with the first line prompted, click YES to All. > (6) You will now have the | character in every space, but there may be > some spaces around it. > (a) Once again select a space, but this time after placing it in the > Find box, > (b) Ensure that the Replace box is empty. > (c) Click OK and Yes to All > (d) Repeat if necesary. > (7) The data space will have contracted itself considerably by the time > you have eliminated the spaces. > (8) The data in question contains comma separated numerals, and they can > often create problems when being transfered between a Text Editor and a > Spreadsheet such as MS Excel or Apache Open Office "Calc". To avoid this, > (a) Select a comma "," and use the Find & Replace function again, and > (b) In the Replace box enter a comma followed by one space ", " > (without the "quotes") > (c) Click OK and Yes to All. > (9) Save the file as - yourfilename.csv and the third line should look > like this:- > > Aspden|244|Gardner|11, 209, 313|Pilkington|267 > > (10)Now is the time to open your Spreadsheet program - or Google > Spreadsheets. > > Part 2 will follow tomorrow. > > Barry > > ------------------------------- > To unsubscribe from the list, please send an email to FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message > -- “Only two things are infinite, the universe and human stupidity, and I’m not sure about the former.” -Albert Einstein "A great moral force is a bayonet on a gun and a web-belt full of cartridges." -Colonel John S. Poland, U. S. Army - 1894 "In all border lands a certain class of men have to be killed to insure the welfare and safety of the peaceably inclined." - Judge William L. Kuykendall - 1917 _ _... ..._ _ _._ ._ ..... ._.. ... .._