function ranges

Michelle_D

Is there a way of creating 2 function ranges together? I need a range that accepts a temperature of either 18-22 C or 64.4 -71.6 F. I tried a regex but understand that this only works with INT numbers. The following was not acceptable: func: range(18.0,22.0)(64.4,71.6)

haensel

Hi

This regexp should work.

((18\.0|22\.0|(19|20|21)\.[0-9])|(64\.[4-9]|(6[5-9]\.[0-9])|70\.[0-9]|71\.[0-6]))

Regards,
Christian

Michelle_D

Is this a Regex? or function? if Regex, i thought you could only use single numbers 0-9 ?

Michelle_D

the second part works (64.4 -71.6) but the first part doesn't

haensel

So maybe there is a little typo or I missed something else but the concept should be clear, or?

Regards,
Christian

Michelle_D

Yeah, thanks. I will check it out.

Michelle Danieli
Data Manager & Accounts
A.Stein-Regulatory Affairs Consulting Ltd.

E-mail: [email protected]
Tel: +972-9-7670002
Fax: +972-9-7668534
Mobile: +972 523 593142 (for whatsapp purposes)

A. Stein -Regulatory Affairs Consulting Ltd.
20 HaTa'as St. (P.O.B. 124)
Beit Hapa'amon Bldg (Suite 102)
Kfar Saba 4442520
ISRAEL

haensel

Could you please provide an example that does not match? I can not find an obvious mistake.

Regards,
Christian

Michelle_D

I have found the problem. I entered 18 and 19, whereas the regexp accepts 18.0 and 19.0 etc. I have to allow for numbers without decimals too.

haensel

Ok.

Good luck

Michelle_D

i got it to work!! thanks for all your help :-))

haensel

No problem. You're welcome.