Remove extra whitespace from IBM AS400 Database

[stig1]

How do you go about removing extra whitespace created in the IBM AS400 Database, as I would like to insert / update the data in my mysql database without having all these extra spaces (think there called characters or something per line)

 

For example

 

White virgin paper made from general wood pulp.                                                                                    It's lint free quality makes it suitable for all electronic cash registers and calculators.

 

Should really look like this:

 

White virgin paper made from general wood pulp. It's lint free quality makes it suitable for all electronic cash registers and calculators.