Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag String Manipulation Rss

Search for any content tagged string manipulation

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 45    Older >>
 

Search a string in a text with number of occurrences

IF you have a long string and if you want to search a specific input string, and number of timeS the string has occurred then it's helps  Read more...
Rating: |  Discuss |   Briefcase | 1,256 reads

Function for String Occurences Count

This function is used to get the particular string occurences count from the given input string.  Read more...
Rating: |  Discuss |   Briefcase | 1,047 reads

Split string using multiple delimiters - version 2

http://www.sqlservercentral.com/scripts/split+string/117123/ The above script will split upto 256 char length only. This new version will split upto N length.  Read more...
By Vignesh Arulmani 2014/11/21 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 1,190 reads

Split string using multiple delimiters

This script is used to split the string using multiple delimiters  Read more...
Rating: |  Discuss |   Briefcase | 1,607 reads

Remove Pattern Matched Characters

Remove characters matched in a patindex pattern recursively.  Read more...
By Steve Holle 2014/10/16 | Source: SQLServerCentral.com | Category: recursive
Rating: |  Discuss |   Briefcase | 1,096 reads

Find only characters or only integer from alphanumeric value

Extract only integers or characters from alphanumeric :  Read more...
By Vimal Lohani 2014/10/07 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,418 reads

Trim Left Char (for single words)

Remove the first replications of a specified char in a word. It does not work well with text that contains blank spaces in the middle.  Read more...
By Adrian Facio 2012/08/16 | Source: SQLServerCentral.com | Category: trim
Rating: |  Discuss |   Briefcase | 927 reads

A CONCAT Function For The Rest Of Us

SQL Server 2012 introduces a new string concatenation function. This can be recreated in earlier versions of SQL Server.  Read more...
By Mike McQuillan 2012/06/06 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 2,092 reads

Stored procedure to find and replace text in a text file

find and replace text in a text file using tsql   Read more...
By Gene Hunter 2012/01/23 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 2,862 reads

IsAlphaNumeric

This script will determine if a string is alphanumeric   Read more...
By Jon McGhee 2011/12/01 | Source: SQLServerCentral.com | Category: input validation
Rating: |  Discuss |   Briefcase | 1,240 reads

Get Item from Delimited List at Position

Returns the item from a delimited list at the specified position. Both position and delimiter are parameters.  Read more...
By Chad Casady 2011/03/10 | Source: SQLServerCentral.com | Category: udf
Rating: |  Discuss |   Briefcase | 1,027 reads

Prepend Value to Delimited List

Takes a delimited list and prepends a value to the beginning.  Read more...
By Chad Casady 2011/03/09 | Source: SQLServerCentral.com | Category: udf
Rating: |  Discuss |   Briefcase | 773 reads

String tokenizing / splitting

We often have need of string splitting in applications. I had need of one in some T-SQL development I am currently doing for a friend.  Read more...
By Irfan Baig 2011/02/25 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 1,930 reads

SQL CLR Function for Email validation and string Split

I have added 2 functions here, one for email validation and another to split the string by specified separator by user.  Read more...
By Bharat Panthee 2010/12/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,452 reads

Format Phone Number function

Function to format phone numbers entered as text.   Read more...
By Harsha Majety 2010/12/07 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 2,061 reads

SQL Function to Split Comma Separated Values and Insert into Table

SQL Function to Split Comma Separated Values and Insert into Table  Read more...
By Lokeshkumar 2010/11/30 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 4,100 reads

Change String to Title Case(Initcap)

This is simple script to change string to title case. It will take string in any case and convert it to initcap.  Read more...
By Abdul Rahman 2010/10/26 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 1,434 reads

UDF: Phone Format

Format phone number to standard format '(xxx) xxx-xxxx' Removes non numeric characters from string and returns standard format.  Read more...
By saul.g.perez 2010/10/27 | Source: SQLServerCentral.com | Category: user defined function
Rating: |  Discuss |   Briefcase | 1,224 reads

Way to Check Multiple LIKE without dynamic SQL

I was asked to do so by one of my colleague. So, I thought to share it with you how to use multiple LIKE conditions.  Read more...
By Atif-ullah Sheikh 2010/09/16 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 3,487 reads

Trim Non-Alpha characters from string

Trim Non-Alpha characters from string  Read more...
By Atif-ullah Sheikh 2010/07/20 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 2,435 reads
   Items 1 to 20 of 45    Older >>