Regular replace string

From LemonWiki共筆
Jump to navigation Jump to search

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

Google Sheet[edit]

Icon_exclaim.gif Notice the Google Sheet limit:

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


Regular expression was not supported well 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: preg_replace - Manual