topic Re: [resolved] tReplaceList replace char with null in Talend Studio

[resolved] tReplaceList replace char with null

Anonymous — Thu, 12 Nov 2015 09:14:46 GMT

I have an Oracle table containing original character values and replacement values. I am using this as a lookup to tReplaceList. How can I replace a character with no value? i.e. a string "abcd" has the b replaced to give "acd"
I've tried no value in the replacement value but this gives a null pointer exception.

Re: [resolved] tReplaceList replace char with null

Anonymous — Thu, 12 Nov 2015 15:34:11 GMT

Use an empty String ("").

Re: [resolved] tReplaceList replace char with null

Anonymous — Fri, 13 Nov 2015 15:33:49 GMT

That doesn't work. In the oracle reference table if I use a null value I get a null pointer exception, everything else just replaces it with the value in the table.

Re: [resolved] tReplaceList replace char with null

Anonymous — Fri, 13 Nov 2015 15:41:55 GMT

An empty String is not null. An empty String is "something", null is nothing. However, I think I see your confusion. Oracle does something ridiculous with empty Strings when you query the data. It assumes an empty String is null (ridiculous behaviour). What you can do is put a tMap between your Oracle query component and your tReplaceList. Use the tMap to replace null with "" (an empty String) and the replacement will work.

Re: [resolved] tReplaceList replace char with null

Anonymous — Fri, 13 Nov 2015 16:01:22 GMT

Yes that works. Thanks.