inserting data in to a calc table - as csv values

Einfach Dinge, die nichts mit XAMPP, Apache Friends, Apache, MySQL, PHP und alle dem zu tun haben. Allerlei halt. ;)

inserting data in to a calc table - as csv values

Postby unleash » 29. June 2013 12:45

hello dear experts

how to insert the following dataset in to a calc-table

with comma-sepeated data-formate - or how would you do this task

note: i have somewhat 1800 or 2000 lines of this:

Code: Select all
{'url': 'http://myurl', 'a_name': 'Mister Spock', 'name': 'Henry Spock', 'email': 'spaceship-enterprise@austin-texas.com'}
{'url': 'http://yoururl', 'a_name': 'Dil Bert', 'name': 'Dil Bert', 'email': 'DilBert@aol.com'}
{'url': 'http://hisurl', 'a_name': 'Ted Bear', 'name': 'Teddy Bear', 'email': 'Teddy-Bear@zoo.com'}

is this doable somehow - should i use a comma-seperated input of data or what whould you do!?
unleash
 
Posts: 141
Joined: 03. December 2011 10:16
Operating System: OpenSuse Linux 12.1

Return to Allerlei

Who is online

Users browsing this forum: No registered users and 3 guests