2011-03-29
Dismiss this until next updateThis documentation has been updated

The latest version of PrintShop Mail is currently 7.1. This documentation was updated on 2011-03-29 and covers the changes made in this version. If you are still using an older version of PrintShop Mail, you can access its documentation by using the Version: menu at the top-right corner of this screen.

If you wish to upgrade to PrintShop Mail7.1, you can do so via the Upgrade Request page. Note that in order to upgrade, you will need a valid OL Care contract as of 2010-09.

VAL

Syntax

VAL(Text)

Description

Returns number in text as data type Number, for use with formulas involving numbers or numeric functions.

Example

VAL ("123") => 123
Parameter description

Text

Any text expression or data field containing a text to be converted to a numeric value.

You can use this function to convert text fields to fields that hold a value.

If you have a text field that holds number characters, you can convert that field so you can do calculations with it.

Example:

The field [COUPON] holds a text, (for example, "7")

VAL([COUPON])/365 => 0.02