Remove extra spaces from string using regular expression, asp.net, c#

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 […]

Database, SQL (Structured Query Language)

Comments Off on Power of CLR (Common Language Runtime) + SQL server 2005, Managed Assembly

Power of CLR (Common Language Runtime) + SQL server 2005, Managed Assembly

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 […]

Internet stuff

Comments Off on Free books on almost every topic

Free books on almost every topic

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, […]