SQL Server Performance

Parse Delimited String (directory path) to get filename.

Discussion in 'Getting Started' started by smf, Jan 11, 2011.

  1. smf New Member

    Hi all, rookie here. I saw some old posts [02-05-2007 by sql_jr) that talk about being able to parse a a string in a column that is delimited by a '' character. In the replies is a reference to Nigel Rivett's function to return a table from a delimited string. http://www.mindsdoor.net/SQLTsql/ParseCSVString.html . If I had the following column, c12345 with the value "C:Documents and SettingssteveDesktopA-text-1.doc"(no quotes), How can I use the ParseCSVString.html or other code to get the filename, A-text-1.doc ?
    Thanks in advance!
  2. Luis Martin Moderator

    Welcome to the forums!.
    I've locked this one.

Share This Page