# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Calculation/TextData/Replace.php

TablePress – Tables in WordPress made easy, version 3.4. 117 lines.

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/TextData/Replace.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Calculation/TextData/Replace.php
- Modified: 2025-08-26T04:06:14+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/TextData/Replace.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Calculation\TextData;

use TablePress\PhpOffice\PhpSpreadsheet\Calculation\ArrayEnabled;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Exception as CalcExp;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Functions;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;
use TablePress\PhpOffice\PhpSpreadsheet\Cell\DataType;
use TablePress\PhpOffice\PhpSpreadsheet\Shared\StringHelper;

class Replace
{
	use ArrayEnabled;

	/**
	 * REPLACE.
	 *
	 * @param mixed $oldText The text string value to modify
	 *                         Or can be an array of values
	 * @param mixed $start Integer offset for start character of the replacement
	 *                         Or can be an array of values
	 * @param mixed $chars Integer number of characters to replace from the start offset
	 *                         Or can be an array of values
	 * @param mixed $newText String to replace in the defined position
	 *                         Or can be an array of values
	 *
	 * @return array<mixed>|string If an array of values is passed for either of the arguments, then the returned result
	 *            will also be an array with matching dimensions
	 */
	public static function replace($oldText, $start, $chars, $newText)
	{
		if (is_array($oldText) || is_array($start) || is_array($chars) || is_array($newText)) {
			return self::evaluateArrayArguments([self::class, __FUNCTION__], $oldText, $start, $chars, $newText);
		}

		try {
			$start = Helpers::extractInt($start, 1, 0, true);
			$chars = Helpers::extractInt($chars, 0, 0, true);
			$oldText = Helpers::extractString($oldText, true);
			$newText = Helpers::extractString($newText, true);
			$left = StringHelper::substring($oldText, 0, $start - 1);

			$right = StringHelper::substring($oldText, $start + $chars - 1, null);
		} catch (CalcExp $e) {
			return $e->getMessage();
		}
		$returnValue = $left . $newText . $right;
		if (StringHelper::countCharacters($returnValue) > DataType::MAX_STRING_LENGTH) {
			$returnValue = ExcelError::VALUE();
		}

		return $returnValue;
	}

	/**
	 * SUBSTITUTE.
	 *
	 * @param mixed $text The text string value to modify
	 *                         Or can be an array of values
	 * @param mixed $fromText The string value that we want to replace in $text
	 *                         Or can be an array of values
	 * @param mixed $toText The string value that we want to replace with in $text
	 *                         Or can be an array of values
	 * @param mixed $instance Integer instance Number for the occurrence of frmText to change
	 *                         Or can be an array of values
	 *
	 * @return array<mixed>|string If an array of values is passed for either of the arguments, then the returned result
	 *            will also be an array with matching dimensions
	 */
	public static function substitute($text = '', $fromText = '', $toText = '', $instance = null)
	{
		if (is_array($text) || is_array($fromText) || is_array($toText) || is_array($instance)) {
			return self::evaluateArrayArguments([self::class, __FUNCTION__], $text, $fromText, $toText, $instance);
		}

		try {
			$text = Helpers::extractString($text, true);
			$fromText = Helpers::extractString($fromText, true);
			$toText = Helpers::extractString($toText, true);
			if ($instance === null) {
				$returnValue = str_replace($fromText, $toText, $text);
			} else {
				if (is_bool($instance)) {
					if ($instance === false || Functions::getCompatibilityMode() !== Functions::COMPATIBILITY_OPENOFFICE) {
						return ExcelError::Value();
					}
					$instance = 1;
				}
				$instance = Helpers::extractInt($instance, 1, 0, true);
				$returnValue = self::executeSubstitution($text, $fromText, $toText, $instance);
			}
		} catch (CalcExp $e) {
			return $e->getMessage();
		}
		if (StringHelper::countCharacters($returnValue) > DataType::MAX_STRING_LENGTH) {
			$returnValue = ExcelError::VALUE();
		}

		return $returnValue;
	}

	private static function executeSubstitution(string $text, string $fromText, string $toText, int $instance): string
	{
		$pos = -1;
		while ($instance > 0) {
			$pos = mb_strpos($text, $fromText, $pos + 1, 'UTF-8');
			if ($pos === false) {
				return $text;
			}
			--$instance;
		}

		return StringHelper::convertToString(Functions::scalar(self::REPLACE($text, ++$pos, StringHelper::countCharacters($fromText), $toText)));
	}
}

```