Top "Substring" questions

Using CHARINDEX and SUBSTRING in a CASE statement

I need to evaluate a field with a CASE statement. The field name is Commodity and is a varchar(255). The …

sql-server sql-server-2012 substring case charindex

SQL- Get the substring after first space and second space in separate columns

I have a column as FullName containg FirstName, MiddleName, LastName in it. For example: FullName: Marilyn Kean Kirkland I want …

sql sql-server-2008 substring charindex

mysql - function like isnull() to check for zero-value

I'm looking for a function to check if a column has the value 0 that behaves like the isnull() function. This …

mysql substring zero isnull

Ignore files with names starting with 'output'

I have a program that generates text files output1.txt, output2.txt, output3.txt, etc.. I want Git to ignore …

git substring glob

Substring from starting to point to next comma Report Builder

I have a dataset result that contains graph values but it's contained in an odd format as follows; [[42016,44969],[{"name":"$41,000/year …

reporting-services substring contains reportbuilder3.0

How to select a string between 2 identical characters in SQL

My initial string is Content-Disposition: attachment; filename="0001.zam" I want to select everything between the two " characters ("0001.zam" in this …

sql-server substring charindex

Regex: capturing groups within capture groups

Intro (you can skip to What if... if you get bored with intros) This question is not directed to VBScript …

regex substring match capture-group

Split string into words

I am looking for the most efficient algorithm to form all possible combinations of words from a string. For example: …

algorithm string dictionary word substring

Haskell: test if list contains specific "sublist"

Is there a trick or a prelude function to test if a list contains a specific substring/sublist? xyz :: [a] …

list search haskell substring sublist

Get first N characters from string without cutting the whole words

I want to know if there an easy way to get only N symbols from string without cutting the whole …

ruby ruby-on-rails-3 jruby substring words