Regular replace string: Difference between revisions
Jump to navigation
Jump to search
m (→Excel) |
m (Text replacement - "Category:Text file processing" to "Category:String manipulation") |
||
| Line 18: | Line 18: | ||
[https://www.php.net/manual/en/function.preg-replace.php PHP: preg_replace - Manual] | [https://www.php.net/manual/en/function.preg-replace.php PHP: preg_replace - Manual] | ||
[[Category:Regular expression]] [[Category:Software]] [[Category:Programming]] [[Category:Data Science]] [[Category: | [[Category:Regular expression]] [[Category:Software]] [[Category:Programming]] [[Category:Data Science]] [[Category:String manipulation]] | ||
Latest revision as of 19:31, 9 March 2021
"Replaces part of a text string with a different text string using regular expressions."
Google Sheet[edit]
- REGEXREPLACE - 文件編輯器說明 in Chinese
- REGEXREPLACE - Docs Editors Help in English
Notice the Google Sheet limit:
- Maximum string length is 50,000 characters in one cell[1]
Excel[edit]
Regular expression was not supported well on Excel. Using the SUBSTITUTE 函數 - Office 支援 function instead.
Notice the Excel limit:
- Nested 64 Substitute Formulas limit.
- Excel function limit 8192 character[2]