topic Re: Tabulator with tExtractPositionalFields in Talend Studio

Tabulator with tExtractPositionalFields

Anonymous — Tue, 28 Jul 2015 10:58:41 GMT

Good Morning,

I am importing a file with a tab-delimited fields.

To do this, I have set the pattern "\ t" but I get an error string.

Exception in component tExtractPositionalFields_1
java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString (Unknown Source)
at java.lang.Integer.parseInt (Unknown Source)
at java.lang.Integer.valueOf (Unknown Source)

What sentence I should use?

Thank You!!

Re: Tabulator with tExtractPositionalFields

Anonymous — Tue, 28 Jul 2015 12:22:30 GMT

Hi,
      For extracting tab separated file select CUSTOM ANSI in the Field Separator
Your data gets tab separated
Please check in the below Screenshot

Re: Tabulator with tExtractPositionalFields

Anonymous — Tue, 28 Jul 2015 12:23:35 GMT

Screenshot: