topic Handling "null" and “” or ‘’ or ‘ values. in Talend Studio

Handling "null" and “” or ‘’ or ‘ values.

Anonymous — Sat, 16 Nov 2024 13:50:04 GMT

Hi,
I have used a input field (String) and wants to validate the field
in Tmap component - (Java project)
How to validate and replace the value 0 if null or ?? or ?? or ? values comes for that particular field in input.
Please let me know your pointers and updates.
Using the below expression i can able to check the null condition alone but not the
?? or ?? or ? values in input
row1.T_amount == null? "0" : row1.T_amount;
Thanks and regards,
Manikandan.R

Re: Handling "null" and “” or ‘’ or ‘ values.

Anonymous — Tue, 11 Aug 2009 07:41:50 GMT

Hello guy
try

row1.T_amount.equals("\"\"")? "0" : row1.T_amount    //for ""

row1.T_amount.equals("\'\'")? "0" : row1.T_amount    //for ''

row1.T_amount.equals("\'")? "0" : row1.T_amount    //for '

Best regards
shong

Re: Handling "null" and “” or ‘’ or ‘ values.

Anonymous — Tue, 11 Aug 2009 13:34:43 GMT

The above solutions leads to Java error.
Please let me know if any other ways to handle the special charecters.
Thanks and Regards,
Mani.

Re: Handling "null" and “” or ‘’ or ‘ values.

Anonymous — Tue, 11 Aug 2009 14:57:35 GMT

Hello
What's the java error message?
Can you show us your source file?
Best regards

shong