ph_getdatawithmask PowerHome formula function
Description
Gets data from a data retrieval area that was selected from an SQL Select and applies a mask.
Syntax
ph_getdatawithmask ( n, row, col, mask )
| Argument |
Description |
|
n
|
The number of the data retrieval area (1 – 10)
|
|
row
|
A long identifying the row you wish to retrieve from.
|
|
col
|
A long identifying the column number you wish to retrieve from.
|
|
Mask
|
A string representing the mask to apply.
|
Return value
String. The data stored within data retrieval area n at row, col with mask applied. If data is of a date type, you could use a mask of “yyyy-mm-dd” to have the date returned in that format. You can also format numeric and time data types.