Replace Strings
Replaces strings that match the conditions of a regular expression.
URL
https://api.excelapi.org/language/regex-replace
Configuration
Configuration | Required | Description |
---|---|---|
text | ✔ | Specifies the target string of the regular expression |
regex | ✔ | Specifies a regular expression |
after | ✔ | Specifies the string to be replaced |
Example
C2:
=WEBSERVICE("https://api.excelapi.org/language/regex-replace?text="&ENCODEURL($A2)&"®ex="&ENCODEURL($B2)&"&after="&ENCODEURL($C2))