You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » EXCEL Null String vs. UPCASE
Post a reply
Topic review (newest first)
- rbaldwin
- 2010-01-15 20:30:29
In the area where you're attempting to upper case the string, try the following: <column> == null ? null : StringHandling.UPCASE(<column>). So, if you currently have an expression editor (text box) with the following:
StringHandling.UPCASE(row1.name)
You'd replace it with:
row1.name == null ? null : StringHandling.UPCASE(row1.name)
What this will do is essentially the following:
if row1.name is null
return null
otherwise
return StringHandling.UPCASE(row1.name)
Hope that answers your question.
- jrbozeman587
- 2010-01-15 19:25:35
Using TOS
Windows XP Professional
MS Office 2002
IBM Mainframe DB2
I am trying to copy data from an Excel file to DB2 using tMap and need to convert a field to uppercase. Some of the input fields are null and the UPCASE function throws a NullPointerException. Do you know how to code around this and where to plug the code into Talend? I am using the Java option, even though I don't know Java.