One Star

treplace, replace null value with "bla", how

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?

11 REPLIES
One Star

Re: treplace, replace null value with "bla", how

forgot to say above, i tried passing the data through a tReplace both before and after the tMap. tried both basic & advanced mode, but again couldn't figure out how to make it look for empty entries.
One Star

Re: treplace, replace null value with "bla", how

Hi Corey,
How about :
row3.ADDRESS1.equals(''") ? "No Address" : row3.ADDRESS1
Cheers,
c0utta
One Star

Re: treplace, replace null value with "bla", how

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?
One Star

Re: treplace, replace null value with "bla", how

Hi Corey,
Doh! The first double quote (") was replaced by two single quotes (''). Try this instead:
row3.ADDRESS1.equals("") ? "No Address" : row3.ADDRESS1
Cheers,
c0utta
One Star

Re: treplace, replace null value with "bla", how

Brilliant! works perfect, can't thank you enough!
One Star

Re: treplace, replace null value with "bla", how

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
Moderator

Re: treplace, replace null value with "bla", how

Hi ddctf,
This thread is very old. You'd better open a new topic for your issue.
Exception in component tMap_1
java.lang.NullPointerException
Here is my expression:
(row1.notes.equals("")) ? "No Notes" : row1.notes

In addition that, please paste your tMap editor screenshot into the new forum.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seventeen Stars

Re: treplace, replace null value with "bla", how

hi,
the reason it's that you've got some null value for row1.notes ...
use the form
"".equals(row1.notes)

to pass null value or manage them (a better solution)
regards
laurent
One Star

Re: treplace, replace null value with "bla", how

"".equals(row1.ID1) ? row2.ID1 : row1.ID1

worked for me, compared to the syntax mentioned before.
Thanks kzone Smiley Happy
One Star

Re: treplace, replace null value with "bla", how

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.
One Star

Re: treplace, replace null value with "bla", how

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