I've been having a tough time importing comma-delimited files into my database tables. I just discovered that most of the errors are similar to this one:
"060 " is not a valid integer value
I checked my spreadsheet - Microsoft Works - and discovered that there's a space after many of my numerals. I'm not sure how to remove these spaces. I didn't see anything in the Help files. I could do a search and replace, but that would also wipe out spaces between words - like...
Tripp<space>County
I just wondered if there's a simple trick anyone knows of for getting rid of spaces like these or preventing them in the first place. Thanks.
Assuming that these are not the last fields in the record a simple Search/Replace operation in a Text Processor would handle this:
Find = space"," <- note that space is an actual space not the word Replace = ","
I note you mention S/R but you need to be more specific on what you are searching for (as I listed above) and not just look for spaces.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]