On 2/10/07, T&B <[EMAIL PROTECTED]> wrote:
Hi all, I have some imported data, where some fields contain numbers with commas denoting thousands separators. How can I change these to actual numbers?
If you're using unix or linux there are very nice tools for cleaning up the data before loading it. look at 'sed', 'awk', or 'ed'. It would be trivial using sed. -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com
