Regular replace string

From LemonWiki共筆
Revision as of 11:34, 6 August 2019 by Planetoid (talk | contribs)
Jump to navigation Jump to search

"Replaces part of a text string with a different text string using regular expressions."

Google Sheet

Icon_exclaim.gif Notice the Google Sheet limit:

  • Maximum string length is 50,000 characters in one cell[1]

Excel

Icon_exclaim.gif Not support regular expression on Excel. Using the SUBSTITUTE 函數 - Office 支援 function instead.

Icon_exclaim.gif Notice the Excel limit:

  • Nested 64 Substitute Formulas limit.
  • Excel function limit 8192 character[2]

PHP

PHP: preg_replace - Manual