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 43    Older >>
 

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 | 938 reads

Split string using multiple delimiters

This script is used to split the string using multiple delimiters  Read more...
Rating: |  Discuss |   Briefcase | 1,407 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 | 979 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,308 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 | 922 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,072 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,813 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,228 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,023 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 | 770 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,906 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,424 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,027 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,029 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,422 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,219 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,468 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,401 reads

Get concatenated value for a column without cursor

This script provides comma separated values of one column for each value of another column. It provides it in SQL 2005 without using cursor.  Read more...
By Nitin Bhargava 2010/07/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,219 reads

Charpad - Character Padding Function

A generic character padding function. Useful for situations where you need fixed width formatting e.g. email reports.  Read more...
By Richard Doering 2010/12/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,934 reads
   Items 1 to 20 of 43    Older >>