Hi ODN,

I hope you don't mind me hijacking the thread a little, but I really liked John's idea of using java.lang.reflect, so gave it a go myself (see code below).  I'm fairly new to java, so I'm not sure if this would be considered robust enough for say production use.

John, if you would do it differently or have any tips ideas regarding robustness/error checking etc then I'd love to capture your thoughts. 

Regards,
Rick

Class cls = Class.forName(input_row.getClass().getName());   
Class clsOut = Class.forName(output_row.getClass().getName()); 

Field fieldlist[] = cls.getDeclaredFields();
Field fieldlistOut[] = clsOut.getDeclaredFields();

for (int i = 0; i < fieldlist.length; i++) {
    Field fld = fieldlist[i];
    Field fldOut = fieldlistOut[i];
    int mod = fld.getModifiers();     
    if ( Modifier.toString(mod).equals("public")) {
        if ( fld.getType().getName().equals("java.lang.String") ) {
            fldOut.set(output_row, "\"" + fld.get(input_row) + "\"");
        } else {
            fldOut.set(output_row, fld.get(input_row));
        }
    }
}

You could do it manually in a map rule by adding " to the start and end of string fields and not setting the csv options in the output file.
OK if there are only a few fields.

Well I edited this topic, because for the first time I was little bit wrong :-)) hehe

I checked tFileInputDelimited and you are able to use "Text enclosure" feature if you check the CSV option on component. So your functionality is already there.

This is also available by creating metadata for delimited file, select type CSV and there already is that option related to "Text-enclousure" as """, then the schema will be based on reading that file in a way:
"alfa" will be String
245 will be Integer

So Talend is already ready for your scenario.

Best regards,

archenroot

Last edited by archenroot (2010-11-15 07:49:01)

Told you so. ;-)

Rick - aka tchd - why are you saying that it has to be tJavaRow? ODN did not specify that...