From owner-freebsd-questions@FreeBSD.ORG Fri Feb 13 20:49:57 2015 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id C8AF4870 for ; Fri, 13 Feb 2015 20:49:57 +0000 (UTC) Received: from mail-la0-f53.google.com (mail-la0-f53.google.com [209.85.215.53]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 6A35A8E7 for ; Fri, 13 Feb 2015 20:49:57 +0000 (UTC) Received: by labpv20 with SMTP id pv20so18627357lab.8 for ; Fri, 13 Feb 2015 12:49:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject :content-type:content-transfer-encoding; bh=AC5bFCUW7uFK4Mym2tgJejfy/FNnkLHAkiC18W4vyNI=; b=Yd8ESi2R1pO2W0lzOc/Ib9DByuf1bcyAxaBE+xZ1CaJUxgsRRG8+5vIuWpKPEGKyqq 8eZwnHFDz/mi/XyAzGRDd/p81k3VouMDcW7ycnnLju3ld4a4CATrbqY/OG5YRapj8aol KMPMUgdZ+ckhf0t011y+PC8N55kRf9J0b2ji4w9LeeBnCUOibM3hqC/SeGV5Ksj2uFzS AzIFBxTt/ppK8+DP0jTKbQyboQ0ufeJCqMJIimghHl4mbLosSJ1v596P0gfcuSrbGqKX McYZLvzYT5pM0TO2t7dczaNE6Xe7VhfBa1+VYYpga5dOb2T//njdGifeaNigg8bbZb/Z bfRw== X-Received: by 10.112.167.4 with SMTP id zk4mr4237110lbb.74.1423860595046; Fri, 13 Feb 2015 12:49:55 -0800 (PST) Received: from lazlar.no-ip.biz (213-64-218-92-no126.business.telia.com. [213.64.218.92]) by mx.google.com with ESMTPSA id x5sm1542918lax.44.2015.02.13.12.49.54 for (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 13 Feb 2015 12:49:54 -0800 (PST) Message-ID: <54DE6371.4070609@gmail.com> Date: Fri, 13 Feb 2015 21:49:53 +0100 From: Rolf Nielsen User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:31.0) Gecko/20100101 Thunderbird/31.4.0 MIME-Version: 1.0 To: User questions Subject: Batch editing an SQLite db Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 13 Feb 2015 20:49:57 -0000 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 I recently changed from one ROM to another on my Android phone. The old one and the new one use different mount points for the external SD card, and because of this the music playlists I've painstakingly created are utterly useless. The player refuses to even open them, because the files in them are non-existent. These are SQLite database files, and I've been able to open them with the SQLiteEditor app for Android, but I've not found an option to replace all occurances of a string with something else. I have eight playlists with some 500 songs each, so editing them manually would be tedious. Is there something in the ports tree that can do this? SQL isn't a language I speak fluently, so I'd need some pointers as well. Basically I need to substitute "sdcard1" for "extSdcard". TIA, Rolf Nielsen -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBCAAGBQJU3mNgAAoJEPJMW41Co4JgIF8P/RZBX6Pk5pb2TXjwQREAYjBT yXmj3GWO9XSBvVlhpgNjpshkYar/H9ZMNVQvOijLf0gt/cQZ1/SeHhSKV9fHhDNl O54PHLbJH3zwJZyS0srxJnkw7YWg+KIxWjNTE3x2vjbmdTT86UryNSMd4kdcYQN6 gP2aJFXC/wjEDLO71Zh2WYD6fsbi1vyxxBz4hXZlfvfQV9J2cGfXXd/HnsC41lia MoAJ+T6MRGwmrt3fYXbVRKixQAZMowfyW7mNQcr5uVjwFHhZcjWXRXfkp+hctyK9 VgKqKfalszjkcyYTxLo45CnFzCF8qhIP2f8zpPhvtHvA15sO9DhpnA6BSkBgOwgB wR8EG3sg9CPLMH0IdAvUVnhQGSuR2fJ9wH/H2QXk3/3LrauUjnpskiEWhDQ5/qZj 9sMIaNPcsuj2EdqSUV3gZlfUHQPakSDO1OuPBoacK2BKQjRaugO/RQpqokm2cXMa KLpBiNGO8kbavCP4uoZmPs3xjhrUSD/8iO0kOt4Pbby9ffFnPVQtHjAWaX1BQLHl BMC0VXEtYrDJjndYpp2tMUuP5iwi3v8QSMviUAeUPMJtW03dlF+rSqBzDKVxbtlw YoNWRICvCbrNFFJJSnxs5GOLk0cVZtJ+jC97Xq6ais3l2ev/HWPnfICYyILlGFK+ onlq3WP7JtF8/luE5FI3 =QZ8L -----END PGP SIGNATURE-----