http://www.thedeal.com/dealscape/2008/12/madoffs_victims_list_reportedl.php
Some guy named “Joe Heller” has posted that info in a few places. You can see this in the above URL. I actually got same info from his post on another site. And it was totally unformatted. Unlike the one above
That is how I posted it here. One big blob. But you formatted it into table form which is great
I’m just curious. Where you able to automate the making of that table? My crude way of doing it would be to chop the blob into one line for each Madoff victim. Done on MS Frontpage. Then save it and open up the page I created. Open with IE
I would then make a four column table (like yours) with 50 rows to start. Then drag and drop the part of each victim’s line that goes into the correct column of new table. This can also be done with Word
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