topic Re: isNum in Talend Studio

isNum

DrGenious — Wed, 19 Feb 2020 11:26:15 GMT

Hi,

I am trying to parse a file and I wrote in tjavarow component this line( boolean numeric = isNumeric(input_row.Cell_Name); ) but it idoesnt run.

How can I convert this expression into order to see if it is numeric and store it into a variable?

Thanks a lot.

manodwhb — Wed, 19 Feb 2020 12:32:05 GMT

@DrGenious , you need to use something like below code.

public static boolean isNumeric(String strNum) {

if (strNum == null) {

return false;

}

try {

double d = Double.parseDouble(strNum);

} catch (NumberFormatException nfe) {

return false;

}

return true;

}

DrGenious — Thu, 20 Feb 2020 05:54:09 GMT

@manodwhb Is not any simplier way? I dont want to declare it as a double , I want only to take the boolean result.

manodwhb — Thu, 20 Feb 2020 09:30:17 GMT

@DrGenious , you need to write specified java otherwise not sure.

cmendels — Thu, 20 Feb 2020 19:35:36 GMT

Talend has a routine Mathematical.NUM(input) that returns 1 if it's a numeric data type and 0 if not. Would that work?