c# remove all white spaces from string

Question

I have an sql string retreiving data for three columns and I dont want any space in betweeen these columns. I want to remove space between columns.

 string stringSql = " SELECT distinct  " +
                   "'" + comboBox6.Text + "' as RecordType" +
                 " , left([Claimant Name] +' ',29) " +
                " , left([Claimant Address1] +' ',29)  " +
                " , left([Claimant Address2] +' ',29) as ClaimantAddress2 " +

My Client requirment is like

**1xyz1dundas**

MY output is like

**1 xyz 1 dundas**

Your question is unclear. What if the claimant name or address contains a space in between. Should we remove that also e.g. `Street 1 Of July` should become `Street1OfJuly` or do you want just remove the ending spaces? Another point to know if your columns are of CHAR datatype or VARCHAR/NVARCHAR — Steve, Feb 28 '14 at 09:31
Yes i dont need spaces in between Street1OfJuly what i want and datatype is varchar. — preethi, Feb 28 '14 at 09:40

score 4 · Answer 1 · answered Feb 28 '14 at 09:24

4

Make use of replace

stringSql .Replace("  ", string.empty);

in sql

 SELECT REPLACE(stringSql, ' ', '')

answered Feb 28 '14 at 09:24

Sajeetharan

203,447
57
330
376

Dmitry Bychenko · Answer 2 · 2018-03-02T10:45:58.727

2

In case you want to remove whitespaces (not just ordinary spaces ' ', but, say, tabluations '\t') you can use LINQ:

  stringSql = new String(stringSql.Where(x => !Char.IsWhiteSpace(x)).ToArray());

edited Mar 02 '18 at 10:45

answered Feb 28 '14 at 09:31

Dmitry Bychenko

165,109
17
150
199

score 1 · Answer 3 · answered Feb 28 '14 at 09:27

1

On SQL-Server:

SELECT REPLACE(yourField, ' ', '')

answered Feb 28 '14 at 09:27

Fabian Bigler

9,721
6
41
64

score 0 · Answer 4 · answered Feb 28 '14 at 09:47

MSSQL Server :

RTRIM(LTRIM(a))

Oracle , MySQL, SQL Server 2012 : TRIM Function

string stringSql = " SELECT distinct  " +
                   "'" + comboBox6.Text + "' as RecordType" +
                 " ,  RTRIM(LTRIM(left([Claimant Name] +' ',29))) " +
                " ,  RTRIM(LTRIM(left([Claimant Address1] +' ',29)))  " +
                " ,  RTRIM(LTRIM(left([Claimant Address2] +' ',29))) as ClaimantAddress2 "

c# remove all white spaces from string

4 Answers4