[resolved] StringHandling.IS_ALPHA() functionality not clear.

[_AnonymousUser]

Hi,
I am using "Jaspersoft ETL" Version: 5.0.2.
My requirement is:
I have a column in postgres database which contains numeric and alphanumeric values. Now I want to filter out numeric values in one file and alphanumeric values in another file.
If I use the function
StringHandling.IS_ALPHA("99") ,it returns "false" in output.
The above output is correct and understood.
But if I use
StringHandling.IS_ALPHA("9") ,it returns "true" in output.
StringHandling.IS_ALPHA("9A") ,it returns "false" in output.
StringHandling.IS_ALPHA("A9") , it returns "true" in output.
I cannot understand the output for "9","9A" and "A9"
I want to know whether the function is providing correct output or not. If the output is correct , then can you help me understand the functionality of IS_ALPHA(). And also, how can I filter out numeric and alphanumeric values in separate file.
Thanks

[Anonymous]

Hi
It should be a bug on v5.0.2, I just tested it on v5.2.1 and it works, please download the latest version and test it again. In the mean time, you can test also the function Mathematical.Num(), it returns true (1) if the argument is a numeric data type; otherwise, returns false (0).
Shong

[_AnonymousUser · Accepted solution]

Hi Shong,
Thanks for your reply. I tried Mathematical.Num(). Its working perfectly.

Regards,

[Anonymous]

Thanks for your feedback, so, you can the function Mathematical.Num() as a alternative solution.
Shong