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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by John Burnette » Using a function to parse/return the Nth...

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

Rate Topic

Display Mode

Topic Options

Author

Message

john.burnette

Posted Monday, October 19, 2009 11:28 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 20, 2009 4:30 PM
Points: 32, Visits: 13

Comments posted to this topic are about the item Using a function to parse/return the Nth field of a delimited column

Post #805442

Ken Hiatt

Posted Friday, November 06, 2009 11:14 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, December 06, 2012 4:37 PM
Points: 56, Visits: 60

There is a slight problem with your first IF statement if you truly intend for the delimiter to be "... any weird combination of characters that you think is unique to the source file..."

The statement would need to be changed to:

IF right(@EntString,LEN(@Delimiter))<>@Delimiter

otherwise your delimiter is limited to 1 character

Post #815099

sqlrd22

Posted Monday, July 02, 2012 9:19 AM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 8:35 AM
Points: 59, Visits: 682

Is there any way of adapting this so that the query took for example the 5th value after a certain value came up in a delimited string? With the certain value arising fairly often.

Post #1323844

« Prev Topic | Next Topic »

Permissions