[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,

View solution in original post


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,

View solution in original post

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog