topic Date format issue in tFileExcelOuput component in Talend Studio

Date format issue in tFileExcelOuput component

Anonymous — Sat, 16 Nov 2024 07:22:18 GMT

Hi,

I am reading data from oracle database to excel file. There is a column with data datatype "18-08-2018", but when extracted to excel it is showing as "Sat Aug 18 18:35:08 IST 2018".

I tried extracting as string from db, but then I got result in excel file as "2018-08-18 18:35:08.0".

I want my output in excel to "18-08-2018". Can anyone help me out?

Re: Date format issue in tFileExcelOuput component

Anonymous — Thu, 01 Nov 2018 07:10:56 GMT

Greetings,

You might want to check your Number Format of Date column in Excel for the first case,

And for the string type you can split it by "space token" and then store first part to Excel.

Regards

Chandra Kant

Re: Date format issue in tFileExcelOuput component

Anonymous — Thu, 01 Nov 2018 07:41:27 GMT

Hi,

If you open a file with Excel, it will reformat the data according to the date settings.

When you are doing data testing and file analysis, the recommendation will be always to open the file with a normal text editor like notepad++, textpad etc. to understand the layout. These editors will not modify the data during presentation layer and will show "as-is" from the file.

Warm Regards,

Nikhil Thampi