Need to remove extra white space from description field.
Posted on 2012-03-28
I have a description column which contains data like this :
"This unit uses the firemaster top, which prevents any accidental discharges.
The canister dimensions are 8 and seven-eight inches by 2 inches. An optional holster can be purchased.
Utilizes the Firemaster Safety Top to prevent accidental discharge
Contains 17% Oleoresin Capsicum which gives 2 million Scoville Heat Units
Has a 3 year shelf life
Can supply up to 150 one-second bursts
Total range of stream is 25-30 feet
Made in USA
Product : SW20"
The problem is I have to save this file as a "Tab Delimited" text file.
All the text in the description needs to be on "one line".
Is there anyway to remove all the extra white space in the description?