Copying a table from an Internet site

[news]

Hi,
I want to use a data table published on the Internet:
http://www.transparency.org/news_room/in_focus/cpi_2006/cpi_table

This html table seems difficult to get imported into a standard
spreadsheet, before using it in SPSS. I am interested in particular in
the data in the second and third columns, country name and corruption
index. When I copy & paste the two columns I get a date format for the
numeric data. I realised that when copying there is an empty space
behind the data. But even after I cut the empty space out the difficulty
remained.

I use an OpenOffice spreadsheet with a French language environment and
changed the decimal delimiter from  comma to point. But spreadsheets
from other programmes seem to have the same difficulty.

Any help appreciated.
Thanks
Frank


--
..........................................
Dr. Frank Thomas
FTR Internet Research
93110 Rosny-sous-Bois
France

[Alexander J. Shackman]

i had success doing the following -

1) copy and paste the table into textpad (http://textpad.com/; shareware)
2) using regular expressions, replace the unnecessary spaces, tabs, and
line-breaks with commas
3) save as .txt
4) read into spss

hth, ajs


On 11/9/06, Frank Thomas <[hidden email]> wrote:

>
> Hi,
> I want to use a data table published on the Internet:
> http://www.transparency.org/news_room/in_focus/cpi_2006/cpi_table
>
> This html table seems difficult to get imported into a standard
> spreadsheet, before using it in SPSS. I am interested in particular in
> the data in the second and third columns, country name and corruption
> index. When I copy & paste the two columns I get a date format for the
> numeric data. I realised that when copying there is an empty space
> behind the data. But even after I cut the empty space out the difficulty
> remained.
>
> I use an OpenOffice spreadsheet with a French language environment and
> changed the decimal delimiter from  comma to point. But spreadsheets
> from other programmes seem to have the same difficulty.
>
> Any help appreciated.
> Thanks
> Frank
>
>
> --
> ..........................................
> Dr. Frank Thomas
> FTR Internet Research
> 93110 Rosny-sous-Bois
> France
>

--
Alexander J. Shackman
Laboratory for Affective Neuroscience
Waisman Laboratory for Brain Imaging & Behavior
University of Wisconsin-Madison
1202 West Johnson Street
Madison, Wisconsin 53706

Telephone: [phone]
FAX: [phone]
EMAIL: [hidden email]
http://psyphz.psych.wisc.edu/~shackman

[news]

Alex,
Thanks Alex, for your friendly help. My demand was far more modest: I
wanted just to understand why something apparently simple did not work
so that next time I will be able to resolve the problem without your help !

Cordialement,
Frank

Alexander J. Shackman wrote:

> i had success doing the following -
>
> 1) copy and paste the table into textpad (http://textpad.com/; shareware)
> 2) using regular expressions, replace the unnecessary spaces, tabs, and
> line-breaks with commas
> 3) save as .txt
> 4) read into spss
>
> hth, ajs
>
>
> On 11/9/06, Frank Thomas <[hidden email]> wrote:
>>
>> Hi,
>> I want to use a data table published on the Internet:
>> http://www.transparency.org/news_room/in_focus/cpi_2006/cpi_table
>>
>> This html table seems difficult to get imported into a standard
>> spreadsheet, before using it in SPSS. I am interested in particular in
>> the data in the second and third columns, country name and corruption
>> index. When I copy & paste the two columns I get a date format for the
>> numeric data. I realised that when copying there is an empty space
>> behind the data. But even after I cut the empty space out the difficulty
>> remained.
>>
>> I use an OpenOffice spreadsheet with a French language environment and
>> changed the decimal delimiter from  comma to point. But spreadsheets
>> from other programmes seem to have the same difficulty.
>>
>> Any help appreciated.
>> Thanks
>> Frank
>>
>>
>> --
>> ..........................................
>> Dr. Frank Thomas
>> FTR Internet Research
>> 93110 Rosny-sous-Bois
>> France
>>
>
>
>
> --
> Alexander J. Shackman
> Laboratory for Affective Neuroscience
> Waisman Laboratory for Brain Imaging & Behavior
> University of Wisconsin-Madison
> 1202 West Johnson Street
> Madison, Wisconsin 53706
>
> Telephone: [phone]
> FAX: [phone]
> EMAIL: [hidden email]
> http://psyphz.psych.wisc.edu/~shackman
>
>

--
..........................................
Dr. Frank Thomas
FTR Internet Research
93110 Rosny-sous-Bois
France