Remove Whitespace

Anthony1200 · Post by **Anthony1200** » Tue Mar 31, 2009 1:29 am

Hi,

I just want to remove white space from a string but the StripWhiteSpace function seems to be missing? So can I use Trim?

Regards,
A

Anthony1200 · Post by **Anthony1200** » Tue Mar 31, 2009 1:38 am

Whoops stupid of me..

Trim(String,' ', "A")

Thanks

v2kmadhav · Post by **v2kmadhav** » Tue Mar 31, 2009 3:35 am

Anthony

Note that this would even strip off the potential white spaces between two words eg: address fields, if you have any.

Using a trim(string) or trim(string, ' ', T) should strip any trailing white spaces...

However can u see the output or the input on a database ?
try to see the dump of that field if the trailing white spaces are 32's.

if they are not 32s then trim might not work.

cheers

ray.wurlod · Post by **ray.wurlod** » Tue Mar 31, 2009 6:39 am

StripWhiteSpace() is for parallel jobs - it's not missing, it's just that you're not in a parallel job.

Trim() has arguments that strip "white space", which includes space characters and tabs, from various parts of the string. If NLS is enabled, then trimmable characters are set in the CHARACTER category of your currently selected locale.