• Login

DataSoft Corporation

String Functions

FunctionDescriptionExample
Ascii(String) Returns the ASCII code value of the leftmost character in a character expression. Ascii('a')
Char(Number) Converts an integerASCIICode to a character. Char(65) + Char(51)
CharIndex(String1, String2) Returns the starting position of String1 within String2, beginning from the zero character position to the end of a string. CharIndex('e', 'devexpress')
CharIndex(String1, String2, StartLocation) Returns the starting position of String1 within String2, beginning from the StartLocation character position to the end of a string. CharIndex('e', 'devexpress', 2)
Concat(String1, ... , StringN) Returns a string value containing the concatenation of the current string with any additional strings. Concat('A', ')', [ProductName])
Contains(String1, SubString1) Returns True if SubString1 occurs within String1; otherwise, False is returned. Contains([ProductName], 'dairy')
EndsWith(String1, SubString1) Returns True if the end of String1 matches SubString1; otherwise, False is returned. EndsWith([Description], 'The end.')
Insert(String1, StartPosition, String2) Inserts String2 into String1 at the position specified by StartPositon Insert([Name], 0, 'ABC-')
Len(Value) Returns an integer containing either the number of characters in a string or the nominal number of bytes required to store a variable. Len([Description])
Lower(String) Returns String in lowercase. Lower([ProductName])
PadLeft(String, Length) Left-aligns the defined string's characters, padding its left side with white space characters up to a specified total length. PadLeft([Name], 30)
PadLeft(String, Length, Char) Left-aligns the defined string's characters, padding its left side with the specified Char up to a specified total length. PadLeft([Name], 30, '<')
PadRight(String, Length) Right-aligns the defined string’s characters, padding its left side with empty space characters up to a specified total length. PadRight([Name], 30)
PadRight(String, Length, Char) Right-aligns the defined string’s characters, padding its left side with the specified Char up to a specified total length. PadRight([Name], 30, '>')
Remove(String, StartPosition) Deletes all the characters from this instance, beginning at a specified position. Remove([Name], 3)
Remove(String, StartPosition, Length) Deletes a specified number of characters from this instance, beginning at a specified position. Remove([Name], 0, 3)
Replace(String, SubString2, String3) Returns a copy of String1, in which SubString2 has been replaced with String3. Replace([Name], 'The ', '')
Reverse(String) Reverses the order of elements within String. Reverse([Name])
StartsWith(String1, SubString1) Returns True if the beginning of String1 matches SubString1; otherwise, False. StartsWith([Title], 'The best')
Substring(String, StartPosition, Length) Retrieves a substring from String. The substring starts at StartPosition and has a specified Length. Substring([Description], 2, 3)
Substring(String, StartPosition) Retrieves a substring from String. The substring starts at StartPosition. Substring([Description], 2)
ToStr(Value) Returns a string representation of an object. ToStr([ID])
Trim(String) Removes all leading and trailing SPACE characters from String. Trim([ProductName])
Upper(String) Returns String in uppercase. Upper([ProductName])

Related Links

Related Articles
Thursday, 27 December 2018 Posted in Expressions Constants, Operators, and Functions
 DataSoft Store  Knowledgebase  Contact Us
 Sitemap  Privacy Policy
    Customer Service


Copyright © 2019 DataSoft Corporation All rights reserved.