IBEBlock string-handling functions

The following string-handling functions are available in IBEBlock:

Function	Description
ibec_Coalesce	Takes two or more arguments and returns the value of the first non-NULL argument.
ibec_Copy	Returns a substring of a string.
ibec_CopyToClipboard	Puts a copy of a string in the clipboard.
ibec_Decode	Has the functionality of an IF...THEN...ELSE statement.
ibec_Length	Returns the number of characters in a string.
ibec_Pos	Returns the index value of the first character in a specified substring that occurs in a given string.
ibec_PosEx	Returns the index value of the first character in a specified substring that occurs in a given string.
ibec_Trim	Trims leading and trailing spaces and control characters from a string.
ibec_Format	Returns a formatted string assembled from a format string and a list of arguments.
ibec_CRLF	Inserts Carriage Return and Linefeed. ]]
ibec_InputQuery	Displays an input dialog that enables the user to enter a string.
ibec_PasswordQuery	...
ibec_Explode	Returns an array of strings.
ibec_AnsiLowerCase	Converts a string to lower case.
ibec_AnsiUpperCase	Converts a string to upper case.
ibec_Concat	Concatenates two or more strings into one.
ibec_QuotedStr	Returns the quoted version of a string.
ibec_StringReplace	Returns a string with occurrences of one substring replaced by another substring.
ibec_StringTurn
ibec_IBTypeToStr
ibec_IBTriggerTypeToStr
ibec_AnsiStringToUTF8	Performs the conversion of an ANSI string to UTF8.
ibec_UTF8ToAnsiString	Performs a conversion of a UTF8 string to an ANSI string.

Follow IBExpertise on:

edit SideBar

the database experts