Hey, first off thanks for offering such a great forum, from what I have seen it looks like an ideal place for problems to be solved! I've working with Talend for a few weeks now and have run into several operations I'd like to create, but just cannot seem to make work. Currently I'm trying to have talend replace empty rows in a certain column of a csv file. I simply want rows with blank address fields to be given a default address value of "no address". I've tried tReplace and expressions in tMap but cannot seem to get it going. in tmap, i tried to put the "replace blank rows with *this*" by putting in: row3.ADDRESS1.replaceAll("","No Address") but that just inserts "No Address" after every single character ad nauseam. So i tried: row3.ADDRESS1.replaceAll('',"No Address") double single quotes instead of double double quotes... "Invalid Character Constant" error upon run. Either my syntax is wrong in telling it to "replace empty values in x column with *this*" or im putting it in the wrong place? suggestions?
thanks for the speedy reply, i just tried that, it gives me "invalid character constant". (i ran it successfully without, put that in, got the error) that looks like its more along the lines of what is needed though.. got any suggestions for modifying that?
Hi, not sure if this thread is still going, but I get an error when I try to add this: Exception in component tMap_1 java.lang.NullPointerException Here is my expression: (row1.notes.equals("")) ? "No Notes" : row1.notes
hi I Have a Excel Sheet That Includes Following: First Name | Last Name | Dept | ________________________________ | Marker | IT | John |Steve |HR | I Want the first name Where there is a blank, Replaced by DNK.is there is any way that we make changes in tMap?Please Help Me with this.
Hi i want log error file suppose while insert/update a record, some records are failed to insert/update in want to log those failed records list into file id name phone city 1 shivi 888 kanpur -- > sucessfully updated in db 2 Atul 999 bangor --> failed to update in db 3 shiv 9973 atlantic - > sucessfully updated in db i want in log file " 2 Atul 999 bangor" record i have done small demo of tlogcatcher but it does not log failed record can any one tell me how to do it? thanks Shivi