https://community.qlik.com/t5/Talend-Studio/tFileInputDelimited-type-mismatch-error/m-p/2370093#M133175 When I use tFileInputDelimited I am getting a data type error for input fields that are not strings. In my case a long and a date. <BR />I get the following errors: <BR />Exception in thread "Thread-1" java.lang.Error: Unresolved compilation problems: <BR /> Type mismatch: cannot convert from String to Date <BR /> Type mismatch: cannot convert from String to long <BR />Here is a sample line from CSV: 6545646S2A7;TEST2222CYYL0000;28-04-2010;1664486487;Very_very_long_string <BR />I looked at the offending lines in the code and I noticed the following: <BR />if (temp_tFileInputDelimited_1.length() &gt; 0) { <BR /> row10.CRC = ParserUtils.parseTo_long(temp_tFileInputDelimited_1); <BR />} else { <BR /> row10.CRC = ""; <BR />} <BR />if (temp_tFileInputDelimited_1.length() &gt; 0) { <BR /> row10.date = ParserUtils.parseTo_Date(temp_tFileInputDelimited_1, "dd-MM-yyyy"); <BR />} else { <BR /> row10.date = ""; <BR />} <BR />If the length is 0 for each of these, shouldn't the values be set to NULL for a date and 0 or NULL for a long rather than "" - (an empty string)? <BR />I realize that I can just set these to strings and then use a tJavaRow or tConvert to convert the strings back into the long and the date, but that seems cumbersome. <BR />Any thoughts? <BR />I am using TOS 4.0.1/Java on Windows Sat, 16 Nov 2024 13:26:42 GMT Anonymous 2024-11-16T13:26:42Z https://community.qlik.com/t5/Talend-Studio/tFileInputDelimited-type-mismatch-error/m-p/2370093#M133175 When I use tFileInputDelimited I am getting a data type error for input fields that are not strings. In my case a long and a date. <BR />I get the following errors: <BR />Exception in thread "Thread-1" java.lang.Error: Unresolved compilation problems: <BR /> Type mismatch: cannot convert from String to Date <BR /> Type mismatch: cannot convert from String to long <BR />Here is a sample line from CSV: 6545646S2A7;TEST2222CYYL0000;28-04-2010;1664486487;Very_very_long_string <BR />I looked at the offending lines in the code and I noticed the following: <BR />if (temp_tFileInputDelimited_1.length() &gt; 0) { <BR /> row10.CRC = ParserUtils.parseTo_long(temp_tFileInputDelimited_1); <BR />} else { <BR /> row10.CRC = ""; <BR />} <BR />if (temp_tFileInputDelimited_1.length() &gt; 0) { <BR /> row10.date = ParserUtils.parseTo_Date(temp_tFileInputDelimited_1, "dd-MM-yyyy"); <BR />} else { <BR /> row10.date = ""; <BR />} <BR />If the length is 0 for each of these, shouldn't the values be set to NULL for a date and 0 or NULL for a long rather than "" - (an empty string)? <BR />I realize that I can just set these to strings and then use a tJavaRow or tConvert to convert the strings back into the long and the date, but that seems cumbersome. <BR />Any thoughts? <BR />I am using TOS 4.0.1/Java on Windows Sat, 16 Nov 2024 13:26:42 GMT https://community.qlik.com/t5/Talend-Studio/tFileInputDelimited-type-mismatch-error/m-p/2370093#M133175 Anonymous 2024-11-16T13:26:42Z https://community.qlik.com/t5/Talend-Studio/tFileInputDelimited-type-mismatch-error/m-p/2370094#M133176 Submitted as bug 0012951 Sat, 01 May 2010 19:38:16 GMT https://community.qlik.com/t5/Talend-Studio/tFileInputDelimited-type-mismatch-error/m-p/2370094#M133176 Anonymous 2010-05-01T19:38:16Z