Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I did a bit more digging with this. I fixed it by editing the ParserUtils.java file and changing the logic to also check for empty strings. I'm on a Mac, so the path to do this on a PC might be different (I'd be surprised if it was though).
TalendV561 ? plugins ? org.talend.librariesmanager_5.6.1.20141207_1530 ? resources ? java ? routines ? system
You'll see a number of if statements where it's checking if s == null. I simply changed this to also check for an empty string by adding || "".equals(s) :
public static Double parseTo_Double(String s) {
if (s == null || "".equals(s)) {
return null;
}
return Double.parseDouble(s);
}
If it finds an empty string, it will return null (which is fine for what I'm doing). If you really do need it to return an empty string, you'll need to expand on the logic above.
Once you've done the above, restart Talend and try and run your job again.