REPLACE

替换字符串中的特定子字符串。

语法

REPLCAE(str, substr, newsubstr)

• str：必需。将要执行替换操作的字符串
• substr：必需。要替换的特定子字符串
• newsubstr：必需。将替换substr特定字符串的另一个字符串

示例

1. REPLACE("abc","a","A") 字符串中字母的替换，返回字符串Abc
2. REPLACE("abc","e","f") substr字符串不在str字符串中，返回字符串abc
3. REPLACE("abc","abcde","xyz") substr超过str字符串内容，返回字符串abc
4. REPLACE("!@#","#","&") 特殊字符的替换，返回字符串!@&
5. REPLACE(A1,"服饰","fushi") 引用单元格A1，返回字符串盛利fushi(鼓楼南街店)
6. REPLACE([门店销售明细表].[门店].[门店名称],"服饰","fushi") 引用模型字段，返回字符串盛利fushi(鼓楼南街店)