SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by John Burnette / Using a function to parse/return the Nth field of a delimited column / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 01:27:48 GMT20RE: Using a function to parse/return the Nth field of a delimited columnhttp://www.sqlservercentral.com/Forums/Topic805442-1673-1.aspxIs 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.Mon, 02 Jul 2012 09:19:48 GMTsqlrd22RE: Using a function to parse/return the Nth field of a delimited columnhttp://www.sqlservercentral.com/Forums/Topic805442-1673-1.aspxThere 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))&lt;&gt;@Delimiterotherwise your delimiter is limited to 1 characterFri, 06 Nov 2009 11:14:28 GMTKen HiattUsing a function to parse/return the Nth field of a delimited columnhttp://www.sqlservercentral.com/Forums/Topic805442-1673-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/ETL/68512/">Using a function to parse/return the Nth field of a delimited column</A>[/B]Mon, 19 Oct 2009 23:28:55 GMTjohn.burnette