Removes extra space from the string using Regular expression. public static readonly RegexOptions Options =         RegexOptions.IgnorePatternWhitespace | RegexOptions.Singleline; public string RemoveExtaSpaces(string text) { Regex regex = new Regex(@”\s{2,}”, Options); text = regex.Replace(text.Trim(), ” “); //This line removes extra spaces and make space exactly one. //To remove the space between the end of a word [...]
Today I used Managed Assembly to use Regular Expression in SQL server 2005. I wanted to search for all records which contain special characters in my data and some foreign characters so I was using following SQL Query Select OrganisationId,organisationname from organisation Where organisationname like ‘%-%’ OR OrganisationName like ‘%&%’ OR OrganisationName like ‘%(%’ OR [...]
http://knowfree.net/ You can find free books here on almost every topic. ajax, php, java, c#, asp, networking training, cisco network, photoshop, graphics, desing, web construction, business ebooks, SAP, oracle, mysql, mssql, .net, dot net, j2ee, j2me, linux, unix, windows, windows vista, office, database, programming, software development, video training, dreamweaver, flash, flash training, css, action script, [...]
