Regular replace string - Revision history

Unknown user: Text replacement - "Category:Text file processing" to "Category:String manipulation"

2021-03-09T11:31:21Z

Text replacement - "Category:Text file processing" to "Category:String manipulation"

← Older revision		Revision as of 19:31, 9 March 2021
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:~~Text file processing~~]]		[[Category:Regular expression]] [[Category:Software]] [[Category:Programming]] [[Category:Data Science]] [[Category:String manipulation]]

Planetoid: /* Excel */

2019-08-06T04:26:54Z

Excel

← Older revision		Revision as of 12:26, 6 August 2019
Line 9:		Line 9:

	== Excel ==		== Excel ==
	~~{{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.		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:

Planetoid at 03:34, 6 August 2019

2019-08-06T03:34:33Z

← Older revision		Revision as of 11:34, 6 August 2019
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 ==

Planetoid: /* Excel */

2019-08-06T03:32:26Z

Excel

← Older revision		Revision as of 11:32, 6 August 2019
Line 6:		Line 6:

	== Excel ==		== Excel ==
	{{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.		{{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}} Notice the Excel limit:
			* Nested 64 Substitute Formulas limit.
			* Excel function limit 8192 character<ref>[https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 Excel specifications and limits - Excel]</ref>

	== PHP ==		== PHP ==

Planetoid: /* Excel */

2019-08-06T02:00:13Z

Excel

← Older revision		Revision as of 10:00, 6 August 2019
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 ==

Planetoid: 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..."

2019-08-06T01:58:18Z

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..."

New page

"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 REGEXREPLACE - 文件編輯器說明] in Chinese
* [https://support.google.com/docs/answer/3098245?hl=en REGEXREPLACE - Docs Editors Help] in English

== 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.

== PHP ==
[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:Text file processing]]