Solved

How do you trim the white space from between two words in a txtbox.

Posted on 2008-10-02
10
932 Views
Last Modified: 2013-12-17
I am trying to trim the white space form between two words in a txt box.  The reason for this is i want to run a query to check the db for a match.  What happens now is lets say i type mike Jones in the textbox and run my query it find it.  but if theres any more than one space between mike and Jones my query returns as no match.

Thanks for any help
0
Comment
Question by:bmanmike39
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
10 Comments
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 22629056
In your case, you may be able to do something like this:
{http://msdn.microsoft.com/en-us/library/fk49wtc1.aspx}
textbox1.Replace(" ", "%");

Open in new window

0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 22629067
% == wildcard for MS SQL Server

If using a different database, use the wildcard you would normally use in a LIKE statement, e.g. "*".
0
 
LVL 30

Expert Comment

by:anarki_jimbel
ID: 22629544
I can give you some generic function to remove extra white spaces from text. Probably it bwtter works for big text but also cam be used in your case. It handles spaces and tabs, i.e all white space characters. BTW performance for big text is better than for regular expressions.
See the snippet:
        private string TrimInnerSpaces(string input)
        {
            char[] inputArray = input.ToCharArray();
            StringBuilder sb = new StringBuilder(inputArray.Length);
            int whiteSpaceCounter = 0;
            char currentChar;
            for (int i = 0; i < inputArray.Length; i++)
            {
                currentChar = inputArray[i];
                if (char.IsWhiteSpace(currentChar))
                {
                    if (whiteSpaceCounter > 0)
                    {
                        // do nothing;
                    }
                    else
                    {
                        whiteSpaceCounter += 1;
                        sb.Append(' ');// append one space
                    }
                }
                else
                {
                   whiteSpaceCounter = 0;
                   sb.Append(inputArray[i]);
                }
            }
 
            return sb.ToString();
        }

Open in new window

0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 59

Expert Comment

by:Kevin Cross
ID: 22629940
anarki_jimbel, are you indicating my String.Replace won't work?  Or are you just offering an alternative?
0
 
LVL 3

Expert Comment

by:trunghieubkit
ID: 22631099
Using the snippet below,
It's yours!

It'll work well with either Tab or Space between the words

Example:
"               Hieu                           Dung          "  =>  "Hieu Dung"
Or
"               Hieu                           Dung         Hien "  =>  "Hieu Dung Hien"

string Elimate(string astrOriginal)
{
    string lstrResult = "";
    string[] lstrSplit = { " ", "\t" }; //Both Space and Tab
    string[] lstrSubs = astrOriginal.Split(lstrSplit, StringSplitOptions.RemoveEmptyEntries);
 
    foreach (string lstrSub in lstrSubs)
    {
        lstrResult += " " + lstrSub;
    }
 
    return lstrResult.Trim();
}

Open in new window

0
 
LVL 30

Accepted Solution

by:
anarki_jimbel earned 250 total points
ID: 22645851
mwvisa1
Really I'm just proposing an alternative. But I am not sure your code will work for a string (text), we are not dealing with a DB here.

trunghieubkit:
you code will work but it's highly inefficient for a big text (just in case).
Better change to (see the snippet):
string Elimate(string astrOriginal)
{
    string lstrResult = "";
    string[] lstrSplit = { " ", "\t" }; //Both Space and Tab
    string[] lstrSubs = astrOriginal.Split(lstrSplit, StringSplitOptions.RemoveEmptyEntries);
 
    lstrResult = string.Join(" ", lstrSubs);
 
    return lstrResult;
}

Open in new window

0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 250 total points
ID: 22645868
@anarki,

I was just curious.

As far as DB, see this from question:
>> The reason for this is i want to run a query to check the db for a match.

My solution was geared around changing the spaces in the text from textbox to "%" so that when passed into the SQL query it will look something like this:

columnname LIKE 'John%Smith'

Thanks for asking as that may not have been clear to the asker.
0
 
LVL 30

Expert Comment

by:anarki_jimbel
ID: 22646329
Agree, probably it's the best solution for the case.
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question