Menu
Amazon QuickSight
User Guide

parseInt Function

parseInt parses a string to determine if it contains an integer value. This function returns all rows that contain a decimal, integer, or null value, and skips any rows that do not. If the row contains a decimal value, it is returned as the nearest integer, rounded down. For example, a value of '2.99' is returned as '2'.

Syntax

Copy
parseInt(expression)

Arguments

expression

The expression must be a string. It can be the name of a field that uses the string data type, a literal value like '3', or a call to another function that outputs a string.

Return Type

Integer

Example

The following example evaluates Field2 to determine if it contains integer values.

Copy
parseInt(Field2)

The following are the given field values.

Copy
Field2 -------- 2 2.1 2a 3 3b (null) 5

For these field values, the following rows are returned.

Copy
2 2 3 (null) 5