blank date field with spaces

[anut]

Hi,

One of the fields in the input file has dates and is of string data type. This field is mapped to a field with date data type in the output. When I load the data into output file, can I load the date i.e. null as a blank with 8 spaces.

Note: I am able to load it is a blank but I want the blank to be 8 spaces.

Thanks,

Archana

[Anonymous]

Hi

Assuming the data type of input data is string and the output is string also,

try this expression:

row1.dateColumn==null?" ":row1.dateColumn

Regards

Shong

[anut]

Output data type is date with a format of yyyyMMdd. If the date is null, I want it to be displayed as 8 spaces (for the format yyyyMMdd) instead of a single blank. I tried the above script but it just adds a single space in the field.