Regular replace string: Difference between revisions
Jump to navigation
Jump to search
m
Text replacement - "Category:Text file processing" to "Category:String manipulation"
m (→Excel) |
m (Text replacement - "Category:Text file processing" to "Category:String manipulation") |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 4: | Line 4: | ||
* [https://support.google.com/docs/answer/3098245?hl=zh-Hant REGEXREPLACE - 文件編輯器說明] in Chinese | * [https://support.google.com/docs/answer/3098245?hl=zh-Hant REGEXREPLACE - 文件編輯器說明] in Chinese | ||
* [https://support.google.com/docs/answer/3098245?hl=en REGEXREPLACE - Docs Editors Help] in English | * [https://support.google.com/docs/answer/3098245?hl=en REGEXREPLACE - Docs Editors Help] in English | ||
{{exclaim}} Notice the Google Sheet limit: | |||
* Maximum string length is 50,000 characters in one cell<ref>[https://gsuitetips.com/tips/sheets/google-spreadsheet-limitations/ Sheets Tips - Google Sheets Tips and Tricks | G Suite Tips]</ref> | |||
== Excel == | == Excel == | ||
Regular expression was not supported well 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}} Notice the Excel limit: | {{exclaim}} Notice the Excel limit: | ||
| Line 15: | 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]] | ||