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

Add a script

   Items 1 to 20 of 39    Next 20 >>
 

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 | 884 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 | 1,954 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,671 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,184 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 | 992 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 | 752 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,767 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,304 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 | 1,861 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 | 3,774 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,374 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,174 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,382 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,240 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,160 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,823 reads

Retrieve numbers from a string

This function will take a string parameter and find all numbers in it.  Read more...
By Boyd Tyrrell 2011/07/20 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 2,736 reads

Using a function to parse/return the Nth field of a delimited column

A useful SQL function to parse a single string with delimited values for the "N"th occurrence  Read more...
By John Burnette 2009/11/06 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 1,150 reads

Splitting the string with unique delimiter.

The statement is splited into columns according the delimter and it has been captured in the table datatype.  Read more...
By Prashanth Jayaram 2009/06/29 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 1,088 reads

Function to return proper case

This function returns the proper case of any given string.   Read more...
By Sean Cooperman 2009/03/19 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 1,261 reads
   Items 1 to 20 of 39    Next 20 >>
 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.