Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-07-28 06:58 AM

Tabulator with tExtractPositionalFields

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!!

Labels (2)
Labels
380 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2015-07-28 08:22 AM
Author

Hi,
      For extracting tab separated file select  CUSTOM ANSI in the Field Separator
Your data gets tab separated
Please check in the below Screenshot                                   
   
380 Views
0 Likes
Anonymous
Not applicable
‎2015-07-28 08:23 AM
Author

Screenshot:
380 Views
0 Likes