Текстовые functions
[ ] indicates optional parameters
ДЛСТР(текст)Returns the length of the input string.
| текст | The string of which you want the length. |
ЗАМЕНИТЬ(старый_текст, нач_ном, число_литер, новый_текст)
Returns a string which is the input string with a specified portion replaced.
| старый_текст | The string you want to convert. |
| нач_ном | The starting position of the text to be removed. |
| число_литер | The number of characters to be removed. |
| новый_текст | The text to be inserted into the string. |
Returns a number which corresponds to the value in the input string. You should not need to use this function, as values are automatically converted from text to numeric when required in formulas.
| текст | The string that you want to convert to a number. |
Returns the position in the character set of the first character in the string.
| текст | The character of which you want the character code. |
Returns a string consisting of the specified number of characters from the beginning of the input string.
| текст | The string of which you want the beginning. |
| число_литер | The number of characters to extract from the string. If this parameter is omitted it defaults to 1. |
НАЙТИ(найти_текст, внутр_текст, [нач_ном])
Returns a number corresponding to the position of one text string within another (case-sensitive).
| найти_текст | The text you want to find. |
| внутр_текст | The text to be searched. |
| нач_ном | The position at which to start searching. If this parameter is omitted it defaults to 1. |
Returns a string corresponding to the input string with any unprintable characters removed.
| текст | The text from which you want to remove unprintable characters. |
ПОВТОР(текст, число_повторений)
Returns a string which is the input string repeated a specified number of times.
| текст | The string you want to repeat. |
| число_повторений | The number of times to repeat the string. |
ПОДСТАВИТЬ(текст, стар_текст, нов_текст, [ном_вхождения])
Returns a string which is the input string with specified text replaced.
| текст | The string you want to convert. |
| стар_текст | The string to be removed from the original text. |
| нов_текст | The string to be inserted in the original text. |
| ном_вхождения | Specifies which occurrence of old_text is to be replaced. If this parameter is omitted then all occurrences are replaced. |
ПОИСК(найти_текст, внутр_текст, [нач_ном])
Returns a number corresponding to the position of one text string within another (not case-sensitive).
| найти_текст | The text you want to find. |
| внутр_текст | The text to be searched. |
| нач_ном | The position at which to start searching. If this parameter is omitted it defaults to 1. |
ПРАВСИМВ(текст, [число_литер])
Returns a string consisting of the specified number of characters from the end of the input string.
| текст | The string of which you want the end. |
| число_литер | The number of characters to extract from the string. If this parameter is omitted it defaults to 1. |
Returns a string which is the input string with all of the characters converted to upper case.
| текст | The string that you want to convert. |
Returns a string which is the input string with the first letter of each word converted to upper case and all of the other characters converted to lower case.
| текст | The string you want to convert. |
ПСТР(текст, нач_ном, число_литер)
Returns a string consisting of the specified number of characters from the specified position of the input string.
| текст | The string of which you want the extract. |
| нач_ном | The starting position of characters to extract from the string. |
| число_литер | The number of characters to extract from the string. |
Returns a string consisting of the input number rounded to the specified number of decimal places and converted to currency format.
| число | The amount that you want to format. |
| дес_цифры | The number of decimal places required. If this parameter is omitted it defaults to 2. |
Returns a string consisting of the input string with any extra spaces removed.
| текст | The string that you want to format. |
Returns the character corresponding to the specified position in the character set.
| число | The number of the character that you want. |
Returns ИСТИНА if the input strings are exactly the same, otherwise ЛОЖЬ.
| текст1 | The first string to be compared. |
| текст2 | The second string to be compared. |
Returns a string which is the input string with all of the characters converted to lower case.
| текст | The string you want to convert. |
СЦЕПИТЬ(текст1, [текст2, ...])
Returns a string consisting of the input strings concatenated together.
| текст1, ... | The strings that you want to concatenate. |
Returns a string which is the input value if it is text, otherwise an empty string.
| значение | The value you want if it is a string. |
ТЕКСТ(значение, строка_формат)
Returns a string consisting of the input number formatted using the specified format string.
| значение | The number that you want to format. |
| строка_формат | The format string to use. |
ФИКСИРОВАННЫЙ(число, [дес_цифры], [без_запятых])
Returns a string consisting of the input number rounded to the specified number of decimal places.
| число | The number that you want to format. | ||||
| дес_цифры | The number of decimal places required. If this parameter is omitted it defaults to 2. | ||||
| без_запятых | Specifies whether to suppress the thousands separator in the formatted number. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |