KannanM3 Member since 2019 19 posts
Idexx Laboratories
Posted: 8 months ago
Last activity: 8 months ago

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
Share this page LinkedIn