treplace, replace null value with "bla", how

[_AnonymousUser]

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?

[Anonymous]

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.

[Anonymous]

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