Generate All Pages

Data Manipulation Functions

CHR	Returns the ASCII character equivalent of an integer.
CLEAR	Clears a variable by setting to 0, false or an empty string depending on its type.
CONCAT	Concatenates 2 or more expressions together
COPY	Returns a substring of a string.
DEC	Decrements the value of an integer variable
DECIMAL	Returns the integer value of a hexadecimal string.
HEX	Returns hexadecimal string of an integer value.
INC	Increment the value of an integer variable optionally by a specified amount
INSET	Test if the first value is matched by any of the listed values.
INT	Convert a number represented as a string of digits to its integer value.
LENGTH	Returns the length of a string (number of characters).
LOWCASE	Returns the original string with all UPPER CASE characters converted to lower case.
MOD	Returns the remainder after integer division. Can also be written as '%'.
NOT	Boolean NOT operator, inverts the value of the boolean expression that follows it.
ORD	Returns the ASCII integer value of the first character of a string.
PATTERNCREATE	Defines search patterns for STRARRAYPMATCH and PATTERNMATCH.
PATTERNDESTROY	Destroys a previously defined pattern.
PATTERNDESTROYALL	Destroys all previously defined patterns.
PATTERNLEVEL	Used to set handling of wildcards and case sensitivity.
PATTERNMATCH	Looks for matching patterns in data.
POS	Returns the start position of a substring within a string.
RANDOM	Generates a pseudo random number between 1 and the maximum value specified.
STR	Convert an integer value to its decimal string equivalent.
STRARRAYCHARS	Returns the number of characters in a single dimension string array.
STRARRAYCONCAT	Adds the contents of one single dimension string array to another.
STRARRAYFLUSH	Clear the contents of a 1 dimensional string array.
STRARRAYPMATCH	Looks for matching patterns in data stored in string array.
STRARRAYPOP	Pops specified number of characters from source to destination string array.
STRARRAYTRIM	Trims specified characters from a string array.
STRARRAYTRUNC	Truncates a string array to specified length.
STRBOTH	Used with @STRARRAYTRIM to specify trim from start or end of string.
STRCONCAT	Concatenates 2 or more expressions together
STRCOPY	Returns a substring of a string.
STRLEFT	Used with STRARRAYTRIM to specify trim start of string.
STRLENGTH	Returns the length of a string in characters/bytes.
STRLOWCASE	Returns the lower case version of a string.
STRPOS	Returns the position of a substring within a string
STRREPLACE	Substitute specified characters of the 1st string with the 2nd string.
STRRIGHT	Used with @STRARRAYTRIM to specify trim end of string.
STRSTRIP	Remove the characters listed in the 2nd string from the 1st string.
STRTRIM	Removes leading and trailing whitespace from a string.
STRUPCASE	Returns the upper case version of the string.
TRIM	Removes leading and trailing whitespace from a string.
UPCASE	Returns the upper case version of the string.

Screen / Input / Output

Keywords

Date & Time

This publication has been prepared and written by Telstra Corporation Limited (ACN 051 775 556), and is copyright. Other than for the purposes of and subject to the conditions prescribed under the Copyright Act, no part of it may in any form or by any means (electronic, mechanical, microcopying, photocopying, recording or otherwise) be reproduced, stored in a retrieval system or transmitted without prior written permission from the document controller. Product or company names are trademarks or registered trademarks of their respective holders.

Note for non-Telstra readers: The contents of this publication are subject to change without notice. All efforts have been made to ensure the accuracy of this publication. Notwithstanding, Telstra Corporation Limited does not assume responsibility for any errors nor for any consequences arising from any errors in this publication.