Use Modify stage for converting null string to empty string

abhilashnair · Post by **abhilashnair** » Sat Apr 24, 2010 12:11 am

What is the syntax to be used within the Specification of Modify Stage if I need to convert a null value into empty string. In short I need the equivalent of NullToEmpty(Fieldname) which we usually use in transformer

ray.wurlod · Post by **ray.wurlod** » Sat Apr 24, 2010 1:43 am

The function is handle_null().

Code: Select all

outcolumn=handle_null(incolumn,"value")

abhilashnair · Post by **abhilashnair** » Mon Apr 26, 2010 4:53 am

I want the the output to be empty string. So can I use

outcolumn=handle_null(incolumn,"") ?

chulett · Post by **chulett** » Mon Apr 26, 2010 6:22 am

Easiest way to answer that question is to try it and see. Don't see why it wouldn't work, however.

abhilashnair · Post by **abhilashnair** » Wed Apr 28, 2010 8:46 am

It works perfectly fine. Thanks