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

Content with tag parse Rss

   Items 1 to 11 of 11   
 

Parse XML to table

A stored procedure that will parse (shred) the contents of any well-formed XML document into a SQL table.  Read more...
By Steven Willis 2013/08/05 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 2,493 reads

PARSE 1

By bitbucket-25253 2012/12/17 | Category: parse
Rating: (not yet rated) |  Discuss |   Briefcase | 2,088 reads

Parsing HTML to SQL using SQLDOM

It is simple to parse HTML directly to SQL, manipulate, and render back to HTML using SQLDOM  Read more...
By David Rueter 2012/04/16 | Source: SQLServerCentral.com | Category: html
Rating: |  Discuss |   Briefcase | 8,783 reads

URI Parser: A set of 20 CLR functions for URI parsing

A set of 20 functions for URI and URL parsing, using .NET's native System.Uri parser  Read more...
By Bret Lowery 2011/07/21 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,237 reads

Delimited String Parser

Parses delimited string into a table of up to 9 varchar fields.  Read more...
By Jano Petras 2008/12/17 | Source: SQLServerCentral.com | Category: parse
Rating: |  Discuss |   Briefcase | 2,471 reads

Finding whitespace in a specific column

A quick way to check a targeted column for whitespace.  Read more...
By Gaby Abed 2008/11/06 | Source: SQLServerCentral.com | Category: whitespace
Rating: |  Discuss |   Briefcase | 906 reads

Delimited String Parsing Functions - TwoCol set

Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.  Read more...
By Jesse Roberge 2008/11/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,134 reads

Delimited String Parsing Functions - Big2D set

Feed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.  Read more...
By Jesse Roberge 2008/10/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,075 reads

Delimited String Parsing Functions - Basic Set

Feed it delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/10/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,588 reads

Delimited String Parsing Functions - 2D set

Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.  Read more...
By Jesse Roberge 2008/10/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,003 reads

Delimited String Parsing Functions - Big Set

Feed it large strings of delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,272 reads
   Items 1 to 11 of 11   
 
Tags
t-sql (7)    
delimited strings (6)    
sql server 2005 (6)    
advanced querying (5)    
arrays (5)    
counter (5)    
development (5)    
nums (5)    
sqlinsider scripts (5)    
string manipulation (5)    
table of numbers (5)    
tally (5)    
sql server 7 (3)    
2-dimensional arrays (2)    
nodes (2)    
ascii (1)    
c# (1)    
delimited data (1)    
dom (1)    
elements (1)    
html (1)    
parser (1)    
parsing (1)    
shred (1)    
sql server 2000 (1)    
sqlclr (1)    
sqldom (1)    
uri (1)    
url (1)    
whitespace (1)    
xml (1)