Remove Duplicate Chars From String



Remove Duplicate Chars From String

CREATE FUNCTION dbo.REMOVE_DUPLICATE_INSTR
(@datalen_tocheck INT,@string VARCHAR(255))
RETURNS VARCHAR(255)
AS
BEGIN
DECLARE @str VARCHAR(255)
DECLARE @count INT
DECLARE @start INT
DECLARE @result VARCHAR(255)
DECLARE @end INT
SET @start=1
SET @end=@datalen_tocheck
SET @count=@datalen_tocheck
SET @str = @string
WHILE (@count <=255)
BEGIN
IF (@result IS NULL)
BEGIN
SET @result=''
END
SET @result=@result+SUBSTRING(@str,@start,@end)
SET @str=REPLACE(@str,SUBSTRING(@str,@start,@end),'')
SET @count=@count+@datalen_tocheck
END
RETURN @result
END
GO
Usage:
SET CONCAT_NULL_YIELDS_NULL OFF
SELECT dbo.Remove_duplicate_instr(<CHAR lengthOF a duplicate SUBSTRING >,<string contain duplicate>)
Example:
To keep char set in a string unique and remove duplicate 3 char long string run this UDF as inline function.
SET CONCAT_NULL_YIELDS_NULL OFF
SELECT dbo.Remove_duplicate_instr(3,123456789123456456)
Resultset:
123456789

Comments

Post a Comment

Popular posts from this blog

Delete Confirmation for Delete ButtonField, TemplateField and CommandField in a GridView in ASP.NET

Introduction: This article explains how to add delete confirmation for ButtonField, CommandField and TemplateField columns in a GridView. In this example, I am using a GridView and delete buttons to just hide the row to keep the demo simple. Markup: < html   xmlns = "http://www.w3.org/1999/xhtml" > < head   runat = "server" >      < title ></ title > </ head > < body >      < form   id = "form1"   runat = "server" >      < asp : GridView   ID = "GridView1"   runat = "server"   Font-Names = "Tahoma"   Font-Size = "Small"          CellPadding = "4"   BorderColor = "#507CD1"   BorderStyle = "Solid"   AutoGenerateColumns = "false"          ForeColor = "#333333"   GridLines = "None"   OnRowDataBound = "GridView1_RowDataBou...
Read more

Selecting/Deselecting all CheckBoxes inside a ListView In ASP.NET

Introduction: This articles shows how to toggle checkboxes selection in a ListView using Javascript. Example in this article shows a ListView populated with random records with SelectAll functionality Background:   Often we are required to make one or multiple selection when different options are presented in a databound control such as GridView, Repeater, ListView so on. It is cumbersome to deselect each item individually when the selection has to be cleared. ListView Header can contain a checkbox to select/deselect items in all items of the ListView. Markup:    < html   xmlns = "http://www.w3.org/1999/xhtml" > < head   id = "Head1"   runat = "server" >      < title ></ title >      < script   type = "text/javascript" >          function  toggleCheckBoxes(source) {       ...
Read more

How to Create 3 Tier Vb.Net Desktop Application

3 Tiers are  DLL (Data Logic Layer) BLL (Business Logic Layer ) UI/UX (User Interface) DLL Code DataAccess.vb Code #Region "Data Access <<Imported NameSpaces>>" Imports System.Data.Odbc Imports System.Data.SqlClient Imports System.Data.OleDb Imports System.Xml Imports System.Data.Common Imports System.Text Imports System.Configuration #End Region #Region "Data Access <<Namespace, Class, Functions, Proeprties, etc.>>" Namespace Kcon.Practices.PrivateLibrary.DataLib     Public Class DataAccess #Region "Private Variables"         Private databaseProviderFactory As DbProviderFactory         Private databaseConnection As DbConnection         Private connectionString As String         Private providerName As String         Private databaseTransact...
Read more