<?php
namespace PhpOffice\PhpSpreadsheet\Calculation;
use DateTimeInterface;
/**
* @deprecated 1.18.0
*/
class TextData
{
/**
* CHARACTER.
*
* @deprecated 1.18.0
* Use the character() method in the TextData\CharacterConvert class instead
* @see TextData\CharacterConvert::character()
*
* @param string $character Value
*
* @return array|string
*/
public static function CHARACTER($character)
{
return TextData\CharacterConvert::character($character);
}
/**
* TRIMNONPRINTABLE.
*
* @deprecated 1.18.0
* Use the nonPrintable() method in the TextData\Trim class instead
* @see TextData\Trim::nonPrintable()
*
* @param mixed $stringValue Value to check
*
* @return null|array|string
*/
public static function TRIMNONPRINTABLE($stringValue = '')
{
return TextData\Trim::nonPrintable($stringValue);
}
/**
* TRIMSPACES.
*
* @deprecated 1.18.0
* Use the spaces() method in the TextData\Trim class instead
* @see TextData\Trim::spaces()
*
* @param mixed $stringValue Value to check
*
* @return array|string
*/
public static function TRIMSPACES($stringValue = '')
{
return TextData\Trim::spaces($stringValue);
}
/**
* ASCIICODE.
*
* @deprecated 1.18.0
* Use the code() method in the TextData\CharacterConvert class instead
* @see TextData\CharacterConvert::code()
*
* @param array|string $characters Value
*
* @return array|int|string A string if arguments are invalid
*/
public static function ASCIICODE($characters)
{
return TextData\CharacterConvert::code($characters);
}
/**
* CONCATENATE.
*
* @deprecated 1.18.0
* Use the CONCATENATE() method in the TextData\Concatenate class instead
* @see TextData\Concatenate::CONCATENATE()
*
* @param array $args
*
* @return string
*/
public static function CONCATENATE(...$args)
{
return TextData\Concatenate::CONCATENATE(...$args);
}
/**
* DOLLAR.
*
* This function converts a number to text using currency format, with the decimals rounded to the specified place.
* The format used is $#,##0.00_);($#,##0.00)..
*
* @deprecated 1.18.0
* Use the DOLLAR() method in the TextData\Format class instead
* @see TextData\Format::DOLLAR()
*
* @param float $value The value to format
* @param int $decimals The number of digits to display to the right of the decimal point.
* If decimals is negative, number is rounded to the left of the decimal point.
* If you omit decimals, it is assumed to be 2
*
* @return array|string
*/
public static function DOLLAR($value = 0, $decimals = 2)
{
return TextData\Format::DOLLAR($value, $decimals);
}
/**
* FIND.
*
* @deprecated 1.18.0
* Use the sensitive() method in the TextData\Search class instead
* @see TextData\Search::sensitive()
*
* @param array|string $needle The string to look for
* @param array|string $haystack The string in which to look
* @param array|int $offset Offset within $haystack
*
* @return array|int|string
*/
public static function SEARCHSENSITIVE($needle, $haystack, $offset = 1)
{
return TextData\Search::sensitive($needle, $haystack, $offset);
}
/**
* SEARCH.
*
* @deprecated 1.18.0
* Use the insensitive() method in the TextData\Search class instead
* @see TextData\Search::insensitive()
*
* @param array|string $needle The string to look for
* @param array|string $haystack The string in which to look
* @param array|int $offset Offset within $haystack
*
* @return array|int|string
*/
public static function SEARCHINSENSITIVE($needle, $haystack, $offset = 1)
{
return TextData\Search::insensitive($needle, $haystack, $offset);
}
/**
* FIXEDFORMAT.
*
* @deprecated 1.18.0
* Use the FIXEDFORMAT() method in the TextData\Format class instead
* @see TextData\Format::FIXEDFORMAT()
*
* @param mixed $value Value to check
* @param int $decimals
* @param bool $no_commas
*
* @return array|string
*/
public static function FIXEDFORMAT($value, $decimals = 2, $no_commas = false)
{
return TextData\Format::FIXEDFORMAT($value, $decimals, $no_commas);
}
/**
* LEFT.
*
* @deprecated 1.18.0
* Use the left() method in the TextData\Extract class instead
* @see TextData\Extract::left()
*
* @param array|string $value Value
* @param array|int $chars Number of characters
*
* @return array|string
*/
public static function LEFT($value = '', $chars = 1)
{
return TextData\Extract::left($value, $chars);
}
/**
* MID.
*
* @deprecated 1.18.0
* Use the mid() method in the TextData\Extract class instead
* @see TextData\Extract::mid()
*
* @param array|string $value Value
* @param array|int $start Start character
* @param array|int $chars Number of characters
*
* @return array|string
*/
public static function MID($value = '', $start = 1, $chars = null)
{
return TextData\Extract::mid($value, $start, $chars);
}
/**
* RIGHT.
*
* @deprecated 1.18.0
* Use the right() method in the TextData\Extract class instead
* @see TextData\Extract::right()
*
* @param array|string $value Value
* @param array|int $chars Number of characters
*
* @return array|string
*/
public static function RIGHT($value = '', $chars = 1)
{
return TextData\Extract::right($value, $chars);
}
/**
* STRINGLENGTH.
*
* @deprecated 1.18.0
* Use the length() method in the TextData\Text class instead
* @see TextData\Text::length()
*
* @param string $value Value
*
* @return array|int
*/
public static function STRINGLENGTH($value = '')
{
return TextData\Text::length($value);
}
/**
* LOWERCASE.
*
* Converts a string value to lower case.
*
* @deprecated 1.18.0
* Use the lower() method in the TextData\CaseConvert class instead
* @see TextData\CaseConvert::lower()
*
* @param array|string $mixedCaseString
*
* @return array|string
*/
public static function LOWERCASE($mixedCaseString)
{
return TextData\CaseConvert::lower($mixedCaseString);
}
/**
* UPPERCASE.
*
* Converts a string value to upper case.
*
* @deprecated 1.18.0
* Use the upper() method in the TextData\CaseConvert class instead
* @see TextData\CaseConvert::upper()
*
* @param string $mixedCaseString
*
* @return array|string
*/
public static function UPPERCASE($mixedCaseString)
{
return TextData\CaseConvert::upper($mixedCaseString);
}
/**
* PROPERCASE.
*
* Converts a string value to proper/title case.
*
* @deprecated 1.18.0
* Use the proper() method in the TextData\CaseConvert class instead
* @see TextData\CaseConvert::proper()
*
* @param array|string $mixedCaseString
*
* @return array|string
*/
public static function PROPERCASE($mixedCaseString)
{
return TextData\CaseConvert::proper($mixedCaseString);
}
/**
* REPLACE.
*
* @deprecated 1.18.0
* Use the replace() method in the TextData\Replace class instead
* @see TextData\Replace::replace()
*
* @param string $oldText String to modify
* @param int $start Start character
* @param int $chars Number of characters
* @param string $newText String to replace in defined position
*
* @return array|string
*/
public static function REPLACE($oldText, $start, $chars, $newText)
{
return TextData\Replace::replace($oldText, $start, $chars, $newText);
}
/**
* SUBSTITUTE.
*
* @deprecated 1.18.0
* Use the substitute() method in the TextData\Replace class instead
* @see TextData\Replace::substitute()
*
* @param string $text Value
* @param string $fromText From Value
* @param string $toText To Value
* @param int $instance Instance Number
*
* @return array|string
*/
public static function SUBSTITUTE($text = '', $fromText = '', $toText = '', $instance = 0)
{
return TextData\Replace::substitute($text, $fromText, $toText, $instance);
}
/**
* RETURNSTRING.
*
* @deprecated 1.18.0
* Use the test() method in the TextData\Text class instead
* @see TextData\Text::test()
*
* @param mixed $testValue Value to check
*
* @return null|array|string
*/
public static function RETURNSTRING($testValue = '')
{
return TextData\Text::test($testValue);
}
/**
* TEXTFORMAT.
*
* @deprecated 1.18.0
* Use the TEXTFORMAT() method in the TextData\Format class instead
* @see TextData\Format::TEXTFORMAT()
*
* @param mixed $value Value to check
* @param string $format Format mask to use
*
* @return array|string
*/
public static function TEXTFORMAT($value, $format)
{
return TextData\Format::TEXTFORMAT($value, $format);
}
/**
* VALUE.
*
* @deprecated 1.18.0
* Use the VALUE() method in the TextData\Format class instead
* @see TextData\Format::VALUE()
*
* @param mixed $value Value to check
*
* @return array|DateTimeInterface|float|int|string A string if arguments are invalid
*/
public static function VALUE($value = '')
{
return TextData\Format::VALUE($value);
}
/**
* NUMBERVALUE.
*
* @deprecated 1.18.0
* Use the NUMBERVALUE() method in the TextData\Format class instead
* @see TextData\Format::NUMBERVALUE()
*
* @param mixed $value Value to check
* @param string $decimalSeparator decimal separator, defaults to locale defined value
* @param string $groupSeparator group/thosands separator, defaults to locale defined value
*
* @return array|float|string
*/
public static function NUMBERVALUE($value = '', $decimalSeparator = null, $groupSeparator = null)
{
return TextData\Format::NUMBERVALUE($value, $decimalSeparator, $groupSeparator);
}
/**
* Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise.
* EXACT is case-sensitive but ignores formatting differences.
* Use EXACT to test text being entered into a document.
*
* @deprecated 1.18.0
* Use the exact() method in the TextData\Text class instead
* @see TextData\Text::exact()
*
* @param mixed $value1
* @param mixed $value2
*
* @return array|bool
*/
public static function EXACT($value1, $value2)
{
return TextData\Text::exact($value1, $value2);
}
/**
* TEXTJOIN.
*
* @deprecated 1.18.0
* Use the TEXTJOIN() method in the TextData\Concatenate class instead
* @see TextData\Concatenate::TEXTJOIN()
*
* @param mixed $delimiter
* @param mixed $ignoreEmpty
* @param mixed $args
*
* @return array|string
*/
public static function TEXTJOIN($delimiter, $ignoreEmpty, ...$args)
{
return TextData\Concatenate::TEXTJOIN($delimiter, $ignoreEmpty, ...$args);
}
/**
* REPT.
*
* Returns the result of builtin function repeat after validating args.
*
* @deprecated 1.18.0
* Use the builtinREPT() method in the TextData\Concatenate class instead
* @see TextData\Concatenate::builtinREPT()
*
* @param array|string $str Should be numeric
* @param mixed $number Should be int
*
* @return array|string
*/
public static function builtinREPT($str, $number)
{
return TextData\Concatenate::builtinREPT($str, $number);
}
}
Service Section
Discover how our services are designed to enhance your NFC Pay experience with convenience, security, and innovative solutions. From managing transactions to secure payments, we are dedicated to providing seamless support every step of the way.
Easily save your credit and debit card details within our app for quick and secure transactions. This feature ensures that your payment information is protected with advanced encryption and can be used for future purchases with just a tap.
Transfer funds quickly and securely between users with our streamlined money transfer service. Simply select the recipient, enter the amount, and authorize the transaction for instant, hassle-free transfers.
Activate your merchant account effortlessly to start receiving payments. Our intuitive setup process ensures that you can begin accepting transactions smoothly, helping your business thrive with minimal setup time.
Keep track of all your transactions in real time through our app. Monitor payment statuses, view transaction history, and manage your account efficiently, ensuring complete control over your financial activities.
Our dedicated support team is available to assist you with any queries or issues. Whether you need help with setting up your account or resolving transaction-related questions, we’re here to provide prompt and reliable assistance.