October 19, 2009 at 11:28 pm
Comments posted to this topic are about the item Using a function to parse/return the Nth field of a delimited column
November 6, 2009 at 11:14 am
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
July 2, 2012 at 9:19 am
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.
May 23, 2016 at 4:42 pm
Thanks for the script.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply