Re: Removing 1st character of string for all entries in field

2009-11-05 Thread Tim Legg
. The REPLACE page there is so unclear, I can't even backwards-comprehend the code using the documentation. Where on earth did you learn to code like this? A one-liner at that, even on an 80-column terminal. Thank you very much! Tim Legg --- On Thu, 11/5/09, Kyong Kim wrote: &g

Removing 1st character of string for all entries in field

2009-11-05 Thread Tim Legg
Hello, I am importing CSV data from a proprietary database into a table in MySQL. Due to a flaw in the proprietary software's export tool, currency values (floats) are always exported with a '$' prefixed to them. This causes a problem where the matching float field in the MySQL table being se

Re: Old Messages

2002-02-13 Thread Tim Legg
You know, I am getting rather fed up with all this too. Tried to unsubscribe, but the admin isn't hearing me or something. I sent 17 unsub requests today and I haven't gotten a single confirmation e-mail yet. They will probably come next week and by that time, the request would have expired. E