Those pesky dialects! Here are some equivalent functions in various languages.
| Language | Syntax | Notes |
|---|---|---|
| Find the first occurrence of one string in another string | ||
| C# | haystack.IndexOf(needle); | Returns zero-indexed offset |
| Excel | =FIND(needle, haystack[, offset]) | Case sensitive, offset indexed from 1 |
| PHP | strpos(haystack, needle); | Returns zero-indexed offset |
| SSIS expressions | FINDSTRING(haystack, needle, offset) | offset indexed from 1 |
| TSQL | CHARINDEX(needle, haystack[, offset]) | offset indexed from 1 |
| Replace one substring with another in a containing string | ||
| Excel | =SUBSTITUTE(haystack, needle, new_needle[, occurrence_num]) | Case-sensitive. occurrence_num specifies which occurrence to replace; default is all. |
| TSQL | REPLACE(haystack, needle, new_needle) | Replaces all occurrences |
| Replace a portion of a string with a new string | ||
| Excel | =REPLACE(haystack, offset, num_chars, new_needle) | offset indexed from 1. Insert one string into another by replacing 0 characters at offset |
| TSQL | STUFF(haystack, offset, num_chars, new_needle) | offset indexed from 1. Insert one string into another by replacing 0 characters at offset |
| Generate a string by repeating another one a number of times | ||
| Excel | =REPT(string, number_of_times) | |
| TSQL | REPLICATE(string, number_of_times) | |