List of Functions Available in Datawindow Expressions

Expressions are most commonly used to create datawindow column property expressions. But the are also used to create filter and find strings.

PowerBuilder Special String Characters

Character Meaning

~n New Line
~f Form feed
~r Carriage Return
~b Backspace
~t Tab
~v Vertical tab
~” Quote
~~ Tilde
~nnn ANSI character numeric
~hnn ANSI character hex
~onn ANSI character octal

Variables

Arrays

Initializing

String ls_array[]

Ls_array = {“value1”, “value2”,“value3”, “value4”}

Set to null

String ls_arrayofnulls

SetNull(ls_arrayofnulls)

// …

// … some code that loads values into ls_array[]

// ..

ls_array – ls_arrayofnulls

Decimal

decimal {4} a,b,d,e,f

decimal {3} c

a = 20.0/3                  // a contains  6.6667
b = 3 * a                   // b contains 20.0001
c = 3 * a                   // c contains 20.000
d = 3 * (20.0/3)            // d contains 20.0000
e = Truncate(20.0/3, 4)     // e contains  6.6666
f = Truncate(20.0/3, 5)     // f contains  6.6667

Default Values

Variable	Default Value
Blob	A blob of 0 length; an empty blob
Char (or character)	ASCII value 0
Boolean	FALSE
Date	1900-01-01 (January 1, 1900)
DateTime	1900-01-01 00:00:00
Numeric (integer, long, decimal, real, double, UnsignedInteger, and UnsignedLong)	0
String	Empty string (“”)
Time	00:00:00 (midnight)

Variable Declaration, setting to null

To set a variable to null in the declaration statement

integer si_dup_printer_adjust = SetNull(si_dup_printer_adjust)

Integer

integer i

i = 32767

i = i + 1     // i is now –32768

String

A standard data type that is characters enclosed in single (‘) or double (“) quotation marks, including a string of 0 length (the empty string “”). The maximum number of characters in a string is 60,000.

Null

integer a, b=100, c

SetNull(c)

a = b+c    // all
statements set a to NULL

a = b - c

a = b*c

a = b/c

Masks

! Upper Case
^ Lower Case
a Alphabetical
x Any character
# Number

Sample format	5	-5	.5
[General]	5	-5	0.5
0	5	-5	1
0.00	5.00	-5.00	0.05
#,##0	5	-5	1
#,##0.00	5.00	-5.00	0.50
$#,##0;($#,##0)	$5	($5)	$1
$#,##0;-$#,##0	$5	-$5	$1
$#,##0;[RED]($#,##0)	$5	($5)	$1
$#,##0.00;($#,##0.00)	$5.00	($5.00)	$0.50
$#,##0.00;[RED]($#,##0.00)	$5.00	($5.00)	$0.50
0%	500%	-500%	50%
0.00%	500.00%	-500.00%	50.00%
0.00E+00	5.00E+00	-5.00E+00	5.00E-01