sailor

I have a mySQL database I am working with that came from an Excel spreadsheet (export to CSV, import with phpMyAdmin). However, when this was done, most of the fields have long strings of spaces at the end of them. Is there any way to get rid of this? Im working with PHP--if someone could suggest a quick PHP script that would run through and chomp the spaces off the end of every cell, Id be most thankful.

__________________
"Good people do not need laws to tell them to act responsibly, while bad people will find a way around the laws."
--Plato

Rawb

what you are looking for is either trim, ltrim or rtrim

Look those up in the PHP manual, and you can figure out exactly what you want to do with them.

But you are basically going to have to do a bunch of database reads, and then a bunch of updates. So, no easy way I know of to do this automatically in phpMyAdmin.

sailor

Awesome, thats exactly what I was looking for. I just wrote a quick script to go through everything and run it through the rtrim() function. Thanks!

__________________
"Good people do not need laws to tell them to act responsibly, while bad people will find a way around the laws."
--Plato

devnull

for future reference, the trim() function strips them from both sides at the same time.

sailor

Thanks. I saw that listed with rtrim() but the spaces came from the CSV file and were all on the right side of the string. I guess I probably should have done trim() anyways--not gonna hurt and woulda made sure...

__________________
"Good people do not need laws to tell them to act responsibly, while bad people will find a way around the laws."
--Plato