topic Re: How to check if some column has string value in it in Talend Studio

How to check if some column has string value in it

_AnonymousUser — Sat, 16 Nov 2024 12:50:31 GMT

Hi All,
I'm working on one scenario. I have one column which is string and I need to store that as Integer in Target.
I know I can convert that using Integer.parseInt() function but the problem is source column have both string as well as numeric value in it. So I want to store numeric value as int in target and string value as null.
EX :
Source (varchar()) Target (Int)
123 123
ABC null

Please suggest your views on the above mentioned scenario.
Thanks,

Re: How to check if some column has string value in it

Anonymous — Tue, 28 Jun 2011 02:08:31 GMT

Hi
Write a routine and hard code to check if the input string is a numeric or a string. For example, go to Repository-->Code-->Routines and create a routine, let's call it MyRoutines:

package routines;
public class MyRoutines {
  
    public static Boolean isNumeric(String str) {
    	if(str.equals("")){
    		return false;
    	}
    	for(int i=str.length();--i>=0;){ 
    		int chr=str.charAt(i); 
    		if((chr<48&&chr!=45)|| chr>57) 
    		return false;
    		} 
    		return true;
    }
}

and then call this routine in the job,
tFileInputDelimited--row1--tMap--tMysqlOutput
MyRoutines.isNumeric(row1.columnName)?Integer.parseInt(row1.columnName):null
Let us know if you have any troubles.
Best regards
Shong

Re: How to check if some column has string value in it

alevy — Tue, 28 Jun 2011 06:05:08 GMT

Mathematical.NUM(<var>) will return 1 if the string parameter is all digits.

Re: How to check if some column has string value in it

_AnonymousUser — Thu, 01 Aug 2013 11:14:58 GMT

Hi,
In the table i have column of data type decimal(12,6) in infobright (mysql) db ,the values in the column have the values
as below:
356.400000
************
-129.840000
how to replace this **** value in the column to zero wherever it occurs

Re: How to check if some column has string value in it

Anonymous — Thu, 01 Aug 2013 15:31:56 GMT

Hi,
In the table i have column of data type decimal(12,6) in infobright (mysql) db ,the values in the column have the values
as below:
356.400000
************
-129.840000
how to replace this **** value in the column to zero wherever it occurs

Read it as a string from db, and then convert it from String to BigDecimal on tMap with the expression as below:

row1.columnName.contains("*")?new java.math.BigDecimal("0"):new java.math.BigDecimal(row1.columnName)

Shong