PrintShop Mail Expression Guide

Functions - Overview

Operator

Function

ABS

Returns the absolute value of a numeric value

AND

Logical operator

ASC

Converts the first character in a string to its numeric ASCII value

BLANK

Outputs a blank page

CHR

Converts an ASCII index number to the corresponding character

CODABAR

Calculates a CODABAR barcode

CODE128

Calculates a CODE128 barcode

CODE39

Calculates a CODE39 barcode

CONTAINS

Returns TRUE if a given string value contains a given string to find, otherwise returns FALSE

COUNTER

Returns the position of a counter

DATE

Converts a date variable in the format  "YYYYMMDD" to a custom format

DIV

Returns the integral part (without decimals) of the result of a division

EAN13

Calculates an EAN13 barcode

EAN8

Calculates an EAN8 barcode

FALSE

Logical operator

FILE_EXISTS

Returns TRUE is the file exist on disk

IF

Logical operator

INT

Returns the integral part of a floating point value

ITF

Calculates an ITF barcode

KIX

Computes a KIX  Barcode

LEFT

Returns a substring of a specified number of characters starting from the left of the text string

LEN

Returns the length of a text string (numeric value)

LOWER

Converts all characters in a text string to lower case

LTRIM

Removes leading spaces, tabs and newline characters from a text string

MID

Returns a substring of a specified number of characters from a text string

MOD

Returns the remainder resulting when dividing two values

MSI

Calculates a MSI barcode

NOT

Logical operator

OR

Logical operator

OBJECT_EMPTY

Returns True if the object with index<object_index> is empty. The back most object has index 1.

PAGE_NR

Returns the page number while printing, otherwise 1 (in the preview)

POS

Searches and returns the position of a substring in a text string (numeric value)

POSTNET

Calculates a POSTNET barcode

PRINT

Prints a page

PROPER

Converts the first letter of each word to an uppercase character, and the rest to lowercase

R_CODE128_J

Calculates R-CODE128_J barcode

R_CODE39_J

Calculates R_CODE39_J barcode

R_EAN128_J

Calculates R_EAN128_J barcode

R_ITF_J

Calculates an Interleaved 2 of 5 barcode

R_JAN13_J

Calculates R_JAN13_J barcode

R_JAN8_J

Calculates R_JAN8_J barcode

R_JAN7_J

Calculates R_JAN7_J barcode

R_UPCA_J

Calculates R_UPCA_J barcode

R_UPCE_J

Calculates R_UPCE_J barcode

R_YUBAR_J

Calculates R_YUBAR_J barcode

REPLACE

Replaces a part of a string with a new string, and returns the result.

RIGHT

Returns a substring of a specified number of characters starting from the right of the text string

ROUND

Rounds a floating point value to the specified number of decimals

RTRIM

Removes trailing spaces, tabs and newline characters from a text string

SGN

Returns the sign (positive or negative) of a value

SKIP

Skips a page - no output

STR

Converts a number to a string

TEXT_FILE

Returns the contents of the TXT or RTF file <string_value>

TODAY

Returns the current date, formatted according to the format specified in the Date format preference panel

TRIM

Removes leading and trailing spaces, tabs and newline characters from a string

TRUE

Logical operator

UPCA

Calculates an UPCA barcode

UPCE

Calculates an UPCE barcode

UPPER

Converts all characters in a text string to uppercase

VAL

Returns the numeric value of a text string