![]() ![]() What RgxTrim is doing additionally is replacing multiple white spaces inside the text with a single white space. They are only trimming white spaces from the left, right or from both sides of a string. The two new functions added to the SqlRegex.dll are RgxTrim() and RgxReplace().īefore starting with them I’ll mention the in-built functions for similar purposes, like the LTRIM and RTRIM functions and TRIM in SQL Server on Linux and starting with SQL 2017 on Windows. My previous post was about searching text in SQL Server using regex, and now I’m showing how to use it for replacing text in SQL Server. In this post, I’m presenting usage of two functions that use Regex. ![]()
0 Comments
Leave a Reply. |