hi folks,
Is there a way to check for integer values for each value in an array? The array can have text or integer values.
I have already tried using like() but its not accurate as the size of the digits change i.e, double digits or triple digit numbers. Checking with tointeger() also failed as it converted text values into integers and when passed to the group() function it gave me an incorrect result.
TIA!!
Discussion posts and replies are publicly visible
One simple method OOTB without the need for regex plugin, is to apply integer and reject the nulls:
fn!reject( fn!isnull, a!forEach( items: {"a",1,"b",2,"c",3}, expression: fn!tointeger(fv!item) ))
Output:
List of Number (Integer): 3 items 1 2 3