topic Re: blank date field with spaces in Talend Studio

blank date field with spaces

anut — Fri, 15 Nov 2024 23:50:51 GMT

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

Re: blank date field with spaces

Anonymous — Tue, 17 Aug 2021 00:34:48 GMT

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

Re: blank date field with spaces

anut — Tue, 17 Aug 2021 14:44:03 GMT

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.