topic Re: Check if a value in a string variable is numeric in Talend Studio

Check if a value in a string variable is numeric

Anonymous — Tue, 26 Aug 2014 11:54:56 GMT

Hello,
How can i check if a Value in a string variable in numeric (integer or real).
Thanks for help
Andreas

Re: Check if a value in a string variable is numeric

Anonymous — Tue, 26 Aug 2014 12:42:15 GMT

You can use regular expression to validate the string as integer or real.
Vaibhav

Re: Check if a value in a string variable is numeric

Anonymous — Tue, 26 Aug 2014 13:11:20 GMT

Hi Vaibhav,
thanks. But im not good in coding Java. Please do you have some code for me.
Andreas

Re: Check if a value in a string variable is numeric

Anonymous — Tue, 26 Aug 2014 13:29:18 GMT

hi,
java parttern 'shortcut' for that :

\d : A digit:
\D : A non-digit:

you can use a tFilterRow tocheck with contains or matches method.
https://help.talend.com/search/all?query=tFilterRow&content-lang=en
https://stackoverflow.com/questions/15130309/how-to-use-regex-in-string-contains-method-in-java
regards
laurent

Re: Check if a value in a string variable is numeric

Anonymous — Tue, 26 Aug 2014 14:00:47 GMT

sorry but i dont know how i use this in a tjavarow.

Re: Check if a value in a string variable is numeric

Anonymous — Tue, 26 Aug 2014 14:10:24 GMT

use tFilterRow. By that way you can have a flow with data matching pattern & reject flow (data doesn't).
see link above to documentation & example from Talend help.
ps : remember that you have shortcut 'F1' to get help for every component directly from your Talend Studio.
regards
laurent