replace

SQL Server replace, remove all after certain character

by

Use LEFT combined with CHARINDEX: UPDATE MyTable SET MyText = LEFT(MyText, CHARINDEX(‘;’, MyText) – 1) WHERE CHARINDEX(‘;’, MyText) > 0 Note that the WHERE clause skips updating rows in which there is no semicolon. Here is some code to verify the SQL above works: declare @MyTable table ([id] int primary key clustered, MyText varchar(100)) insert … Read more

Can I use sed to manipulate a variable in bash?

by

Try this: website=$(sed ‘s”https://stackoverflow.com/”\\/|g’ <<< $website) Bash actually supports this sort of replacement natively: ${parameter/pattern/string} — replace the first match of pattern with string. ${parameter//pattern/string} — replace all matches of pattern with string. Therefore you can do: website=${website////\\/} Explanation: website=${website // / / \\/} ^ ^ ^ ^ | | | | | | | … Read more

String.Replace() vs. StringBuilder.Replace()

by

Using RedGate Profiler using the following code class Program { static string data = “abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz”; static Dictionary<string, string> values; static void Main(string[] args) { Console.WriteLine(“Data length: ” + data.Length); values = new Dictionary<string, string>() { { “ab”, “aa” }, { “jk”, “jj” }, { “lm”, “ll” }, { “yz”, “zz” }, { “ef”, “ff” }, … Read more

Replace multiple strings at once

by

You could extend the String object with your own function that does what you need (useful if there’s ever missing functionality): String.prototype.replaceArray = function(find, replace) { var replaceString = this; for (var i = 0; i < find.length; i++) { replaceString = replaceString.replace(find[i], replace[i]); } return replaceString; }; For global replace you could use regex: … Read more