Regular replace string: Difference between revisions
Jump to navigation
Jump to search
(Created page with ""Replaces part of a text string with a different text string using regular expressions." == Google Sheet == * [https://support.google.com/docs/answer/3098245?hl=zh-Hant REGEX...") |
m (→Excel) |
||
Line 6: | Line 6: | ||
== Excel == | == Excel == | ||
{{exclaim}} Not support regular expression. Using the [https://support.office.com/zh-tw/article/substitute-%E5%87%BD%E6%95%B8-6434944e-a904-4336-a9b0-1e58df3bc332 SUBSTITUTE 函數 - Office 支援] function instead. | {{exclaim}} Not support regular expression on Excel. Using the [https://support.office.com/zh-tw/article/substitute-%E5%87%BD%E6%95%B8-6434944e-a904-4336-a9b0-1e58df3bc332 SUBSTITUTE 函數 - Office 支援] function instead. {{exclaim}} Nested 64 Substitute Formulas limit. | ||
== PHP == | == PHP == |
Revision as of 10:00, 6 August 2019
"Replaces part of a text string with a different text string using regular expressions."
Google Sheet
- REGEXREPLACE - 文件編輯器說明 in Chinese
- REGEXREPLACE - Docs Editors Help in English
Excel
Not support regular expression on Excel. Using the SUBSTITUTE 函數 - Office 支援 function instead. Nested 64 Substitute Formulas limit.