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

One Star

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

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

Accepted Solutions
One Star

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

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

Regards,

All Replies
Community Manager

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

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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

Regards,
Community Manager

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

Thanks for your feedback, so, you can the function Mathematical.Num() as a alternative solution.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business