Removing excess white space

[Guest]

I am building up the validation expression for a RegularExpresionValidator
control by retreiving some values from a database and looping through the
DataTable to build and adding lots of | characters. Basically i want to
build up a string along the lines of ^102|103|104|105$ where the number are
coming from the data table. This is easy enough and works fine.
Unfortunately the data values from the database are padded out with loads of
spaces at the end which builds a string like ^102 |103 |104
|104 |$ which doesn't seem to work for the validation expression.
How do i remove the extraneus white space from the end of data before adding
it to the string variable. Bearing in mind that the data in the database is
not always the same length.

 

[Guest]

Just an idea clickon
Trim the data in sql.
http://msdn2.microsoft.com/en-us/library/ms139947.aspx
select trim(name) from books

Good Luck
DWS

 

[Guest]

Unfortunately TRIM doesn't apear to be a TSQL function. At least it doesn't
work with SQL 2000, it just returns a "no such funtion as TRIM exception.

 

[Chris Fulstow]

Hi,

Once you've got the string from your DataTable, you can remove any
white space from the beginning and end using the Trim() method, e.g.:

regExp += "|" + myString.Trim(); // use a StringBuilder instead

For more info on Trim(), see MSDN:
http://msdn2.microsoft.com/en-US/library/t97s7bs3(VS.80).aspx

Hope that helps,

Chris

 

[Chris Fulstow]

Try RTRIM(str), this returns a string after removing all trailing
blanks.

SQL Server Books Online:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_6xm5.asp