TD_StrApply is a string manipulation function that applies a regular expression pattern to a string and returns a new string with the matches replaced by a specified replacement string. This function supports several string operators such as Trimming, Padding, Upper, and so on.
For example, suppose you have a table called employees with a column called email, which contains email addresses in the format firstname.lastname@company.com. You want to replace ‘.’ character with a ‘_’ character in all of the email addresses. You use the TD_StrApply function to achieve this.