john white [via SQLite] wrote: > I have a bit of a problem. I am moving a program (sickbeard) from > windows to ubuntu. The program has an sqlite database. It lists a > variety of things with their physical location on disk. The problem is > that ubuntu (linux) location information is slightly different between > windows and ubuntu so I must change those locations. Oh, there is a > location column with this information. I can do them, one at a time, > but that is going to take a LOT of time. I was hoping there would be a > way to select them all and then simply do a find and replace thing. > > An example would be: "C:\TV\" which should now be '/TV/". Even better > would be to change all the "\" to "/" and then just delete the leading > "C:". > > Thank you........... > > ------------------------------------------------------------------------ > If you reply to this email, your message will be added to the discussion > below: > http://sqlite.1065341.n5.nabble.com/quetion-on-editing-a-sqlite-database-tp71297.html > > To unsubscribe from SQLite, click here > <http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=2&code=bG1oX3VzZXJzLWdyb3Vwc0Btb2xjb25uLmNvbXwyfC02ODY4MzM2NjI=>. > NAML > <http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> >
You might try to export the database file to something like csv. One you have it in a text file format, you could do things like find and replace in a text editor or excel. Once you have things sorted, you could re-import the csv into SQLite. The Firefox SQLite manager lets you export a table from a database and also to import one, so that might work for you. LMH -- View this message in context: http://sqlite.1065341.n5.nabble.com/quetion-on-editing-a-sqlite-database-tp71297p71298.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
