Talend community forum / [resolved] two little problem, just open a file and verify the file format

Ryuk- · 2012-05-09 15:29:33

Tags: [component, Open File, verify file format]

Hi all,

So, i have 2 question:
1) I need to know if Talend can just open a file, if he can, which component?

2) I need to verify the file format, but how can i make it?

Thanks
Ryuk-

pedro · 2012-05-10 05:12:55

Hi Ryuk-

Q1: If you want to simply open a file, I think you might use tSystem to do this.
Q2: Use tFileProperties and get suffix name from basename column.

Regards,
Pedro

Ryuk- · 2012-05-10 11:47:04

Hi Pedro,

Thanks for your answer, but i have a little problem with the tSystem component...

I have this in my component:
"cmd D:\Talend\TOS_DI-Win32-r78327-V5.0.2\workspace\test_CCBO\fichier_STR_standard_CCBO.txt"

But Talend display this error:
Séquence d'échappement non valide (les séquences valides sont \b \t \n \f \" \' \\) (APPROXIMATELTY IN ENGLISH: Invalid escape sequence (the valid sequences are \ b \ t \ n \ f \" \' \ \)

it's possible to know if the file is open?

Can you help me?

Best regards
Ryuk-

Last edited by Ryuk- (2012-05-10 11:47:55)

pedro · 2012-05-10 11:52:50

Hi Ryuk-

The command in tSystem should be this.

Code:

"cmd /c D:/Talend/TOS_DI-Win32-r78327-V5.0.2/workspace/test_CCBO/fichier_STR_standard_CCBO.txt"

Regards,
Pedro

Ryuk- · 2012-05-10 11:59:26

Hi Pedro,

Thanks for your help.

Best Regards
Ryuk-

Announcement

Unanswered posts

#1 2012-05-09 15:29:33

[resolved] two little problem, just open a file and verify the file format

#2 2012-05-10 05:12:55

Re: [resolved] two little problem, just open a file and verify the file format

#3 2012-05-10 11:47:04

Re: [resolved] two little problem, just open a file and verify the file format

#4 2012-05-10 11:52:50

Re: [resolved] two little problem, just open a file and verify the file format

Code:

#5 2012-05-10 11:59:26

Re: [resolved] two little problem, just open a file and verify the file format

Board footer