topic Re: Replace 0 (zero) by NULL with treplace (or other component) in Talend Studio

Replace 0 (zero) by NULL with treplace (or other component)

_AnonymousUser — Sat, 16 Nov 2024 13:36:53 GMT

Hello,
i want to replace the value 0 by NULL with treplace, but this dosn´t work.
I'm on talend 4.0
I try 0 to null > error
I try "0" to null > error
I try 0 to > no error but nothing happens the zero still appears in tlog
I try "0" to > no error but nothing happens the zero still appeas in tlog
Please help me to find my mistake.
Thanks
Sebastian1234

Re: Replace 0 (zero) by NULL with treplace (or other component)

Anonymous — Wed, 13 Jan 2010 06:41:07 GMT

Hello
What's the data type of this column? You can replace it on tMap:
Assuming the data type is String,

row1.value.equals("0")?null:row1.value

Best regards

shong

Re: Replace 0 (zero) by NULL with treplace (or other component)

_AnonymousUser — Wed, 13 Jan 2010 18:57:30 GMT

Hello,
ok i will have a try.
It is a integer so i think it musst be
row1.value.equals(0)?null:row1.value
Thanks a lot!
Sebastian1234

Re: Replace 0 (zero) by NULL with treplace (or other component)

Anonymous — Thu, 14 Jan 2010 06:07:30 GMT

Hello
If it is a Integer, try

row1.value==0?null:row1.value

Best regards
shong