Unknown decimal numbers in resident where clause

[jarrad_murray]

Hi All,

Is there a way to quantify unknown decimal numbers in a where clause of a residential load?

In SQL The where clause would look like

Where

     ActivityNumber not like [0-9]+','+[0-9]%

What i am trying to achieve is find the last date in a data set where the activity isn't a decimal value (decimal values are all forecast).

Many thanks.

[maxgro · Accepted solution]

maybe checking for a .  in the text

if you find a . --> decimal

load

     .....

where not index(text(yourfield), '.')

resident ....

x:

load * inline [

yourfield

12345

12345.32

];

y:

NoConcatenate LOAD

*

Resident x

where not index(text(yourfield), '.');

DROP Table x;

[jarrad_murray]

That would do it, was so focused on how to identify an unknown number I ioverlooked the actual decimal point.

Many thanks.