Free Republic
Browse · Search
News/Activism
Topics · Post Article

To: dennisw

Here are the steps I used to make this table:

Copied the blob into Word.

Looked for patterns of repetition to make sense of the information.

Saw the dollar signs, did a search and replace for those from “$” to “^t$”

Put a hard return after each incidence of the phrase “illion” by searching for it and replacing with “illion ^p”

Manually entered tab symbols after each name and fund type

Created the table by converting it in the Table/Convert dialog box.

Did quite a bit of drag and drop due to the way the data was formatted. I did miss one source, the very first line was credited to Bloomberg which is down on the line for Fortis. I fixed that after posting, of course.

Sorted the table on the first field.

Saved as HTML.

Opened the file in a browser.

Used View/Source to see the HTML formatting, copied that and pasted it into the posting box. Preview seemed ok, so posted it here.

Found one discrepancy, of course. :P


77 posted on 01/05/2009 4:56:59 AM PST by TenthAmendmentChampion (Be prepared for tough times. FReepmail me to learn about our new survival thread!)
[ Post Reply | Private Reply | To 73 | View Replies ]


To: TenthAmendmentChampion

Very interesting ....thanks much
I will try that on 1/4 of the blob

Is there such thing as a source in Word documents?
Like there is HTML source for simple web pages


79 posted on 01/05/2009 7:57:57 AM PST by dennisw (On the 31st floor a gold plated door won't keep out the Lord's burning rage ---FBB)
[ Post Reply | Private Reply | To 77 | View Replies ]

Free Republic
Browse · Search
News/Activism
Topics · Post Article


FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson