[resolved] tReplaceList replace char with null

[Anonymous]

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.

[Anonymous]

Use an empty String ("").

[Anonymous]

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.

[Anonymous · Accepted solution]

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.

[Anonymous]

Yes that works. Thanks.