Talend community forum / Detect an archived file or Excel automatically

PM_param · 2012-03-27 17:21:37

Tags: [archive, CSV file, delimited file, excel, java, type]

Hello,

My job use several file types: txt, archive or Excel. It must be able to automatically detect if it's an archive or an Excel file.
Sometimes files have an extension ". Txt" then it's archive ...

Is there a component Talend to detect this?
Otherwise how JAVA can I use?

Thank you,
Carole

pedro · 2012-03-28 07:18:01

Hi

Link tFileProperties with tFilterRow.
Check "Advanced mode" of tFilterRow.
Set expression of basename.
Get extension at the right of "." .

Code:

(input_row.basename.substring(StringHandling.INDEX(input_row.basename,".")+1)).equals("txt")

Regards,
Pedro

PM_param · 2012-03-28 09:45:27

Hi,

The problem is that the files do not always have the right extension. So I would need an equivalent of the "file-i" on unix.
Does it exist in talend or java?

Thank you,
Carole

pedro · 2012-03-28 10:01:25

Hi Carole

There isn't a component equivalent to "file -i".
You can only use tFileProperties to get the basename of each file.
And use tFilterRow or tMap to filter the extension.

Regards,
PEDRO

Announcement

Unanswered posts

#1 2012-03-27 17:21:37

Detect an archived file or Excel automatically

#2 2012-03-28 07:18:01

Re: Detect an archived file or Excel automatically

Code:

#3 2012-03-28 09:45:27

Re: Detect an archived file or Excel automatically

#4 2012-03-28 10:01:25

Re: Detect an archived file or Excel automatically

Board footer