topic How to read date from TXT file? in Talend Studio

How to read date from TXT file?

smore1665386696 — Fri, 15 Nov 2024 21:12:42 GMT

How to read date from TXT file in talend job, dates can be changed whenever the user wants. Date format is like 23_2_2023. And also save files from input before and after changes in file name as a back up using tfile copy .

Re: How to read date from TXT file?

Anonymous — Fri, 01 Dec 2023 08:26:05 GMT

Using tFileInputDelimited to read a txt file, select 'Date' type for the date column on the schema and set the date pattern as "dd_M_yyyy".

Regards

Shong

Re: How to read date from TXT file?

smore1665386696 — Mon, 04 Dec 2023 09:03:21 GMT

But we are using tcontext component for how to do it further

Re: How to read date from TXT file?

Anonymous — Mon, 04 Dec 2023 09:42:19 GMT

Using tContextLoad to load the values of context variables? If so, you can only read the data as a string from TXT file, if you need to use the value as a Date, you can convert the string to a Date with the below expression:

TalendDate.parseDate("dd_M_yyyy", context.varName)