to many spaces :s
Posted: Mon Jan 17, 2005 9:20 am
Hi everyone,
i've got the following 'pain in the ass' problem:
i had added for about 800 students in my mysql-db.
For that, i used copy paste for the names. Now, between the last and forname there are more than one spaces.
Example:
I dont want to manually change all the 800 names to delete the extra spaces. Anybody knows a sollution to automatically detect if there are more than one spaces, and if yes, make just oner of it?
Friendly greetings from belgium
tom
feyd | added code tags to show detail
i've got the following 'pain in the ass' problem:
i had added for about 800 students in my mysql-db.
For that, i used copy paste for the names. Now, between the last and forname there are more than one spaces.
Example:
Code: Select all
Behets TomFriendly greetings from belgium
tom
feyd | added code tags to show detail