topic Re: treplace, replace null value with "bla", how in Talend Studio

treplace, replace null value with "bla", how

_AnonymousUser — Sat, 16 Nov 2024 14:06:37 GMT

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?

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

_AnonymousUser — Sun, 04 Jan 2009 01:57:56 GMT

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.

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

c0utta — Sun, 04 Jan 2009 11:45:44 GMT

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

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

_AnonymousUser — Sun, 04 Jan 2009 12:48:33 GMT

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?

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

c0utta — Sun, 04 Jan 2009 22:44:11 GMT

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

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

_AnonymousUser — Sun, 04 Jan 2009 23:58:40 GMT

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

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

Anonymous — Fri, 22 Nov 2013 22:53:36 GMT

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

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

Anonymous — Mon, 25 Nov 2013 08:20:19 GMT

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

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

Anonymous — Mon, 25 Nov 2013 08:49:45 GMT

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

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

Anonymous — Thu, 19 Dec 2013 09:53:15 GMT

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

worked for me, compared to the syntax mentioned before.
Thanks kzone

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

Anonymous — Mon, 16 Feb 2015 10:22:32 GMT

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

Anonymous — Thu, 06 Oct 2016 05:29:45 GMT

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