Kannan Manickam (KannanM3)
Idexx Laboratories

Idexx Laboratories
KannanM3 Member since 2019 19 posts
Idexx Laboratories
Posted: January 29, 2020
Last activity: February 27, 2020
Posted: 29 Jan 2020 19:32 EST
Last activity: 27 Feb 2020 23:25 EST

Check String for "", null, number, decimal and only String

I have a input string that need to be checked and set the appropriate flag to true or false. Pls let me know how to do it.

1. If the input string is "" or null set stringIsEmpty to true

- I tried @equals(.value, "") || @equals(.value, null) but it never works

2. If the input string is number or decimal set stringIsIntOrDecimal to true

- I have a custom function which works if its a whole number or decimal number but fails for "abc1.23"

3. If the input string is just "String" with only characters "a" thru "z" set stringIsString to true

- I tried @pxContainsViaRegex(.value,"[a-zA-Z]",false) but doesnt work

Low-Code App Development Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.