topic How to import tab-separated text directly into tabular data with the "Import Multiple Files" function? in Discussions

How to import tab-separated text directly into tabular data with the "Import Multiple Files" function?

lala — Sun, 17 Dec 2023 10:32:29 GMT

I have set this up, but the imported data still cannot be directly tabular.

Thanks!

Multiple File Import(
	<<Set Folder( "C:\7\" ),
	<<Set Show Hidden( 0 ),
	<<Set Subfolders( 0 ),
	<<Set Name Filter( "*.*;" ),
	<<Set Name Enable( 0 ),
	<<Set Size Filter( {1491, 2610} ),
	<<Set Size Enable( 0 ),
	<<Set Date Filter( {3785240875.633, 3785241343.586} ),
	<<Set Date Enable( 0 ),
	<<Set Add File Name Column( 1 ),
	<<Set Add File Size Column( 0 ),
	<<Set Add File Date Column( 0 ),
	<<Set Import Mode( "Row Per Line" ),
	<<Set Charset( "gb2312" ),
	<<Set Stack Mode( "Stack Similar" ),
	<<Set CSV Has Headers( 1 ),
	<<Set CSV Allow Numeric( 1 ),
	<<Set CSV First Header Line( 1 ),
	<<Set CSV Number Of Header Lines( 1 ),
	<<Set CSV First Data Line( 1 ),
	<<Set CSV EOF Comma( 1 ),
	<<Set CSV EOF Tab( 1 ),
	<<Set CSV EOF Space( 1 ),
	<<Set CSV EOF Spaces( 0 ),
	<<Set CSV EOF Other( "" ),
	<<Set CSV EOL CRLF( 1 ),
	<<Set CSV EOL CR( 1 ),
	<<Set CSV EOL LF( 1 ),
	<<Set CSV EOL Semicolon( 0 ),
	<<Set CSV EOL Other( "" ),
	<<Set CSV Quote( "\!"" ),
	<<Set CSV Escape( "" ),
	<<Set XML Method( "guess" ),
	<<Set XML Guess( "huge" ),
	<<Set XML Settings( XML Settings() ),
	<<Set JSON Method( "guess" ),
	<<Set JSON Guess( "huge" ),
	<<Set JSON Settings( JSON Settings() ),
	<<Set Import Callback( Empty() )
) << Import Data

回复： How to import tab-separated text directly into tabular data with the "Import Multiple Files" function?

lala — Sun, 17 Dec 2023 10:34:42 GMT

93146	1166	1000
93146	1167	500
93146	1167	200
93259	1167	300
93259	1167	1000
93259	1167	600
93323	1168	900
93417	1163	-700
93504	1163	-300
94507	1163	-200
94507	1163	-400
94546	1167	400
94546	1167	1200
94621	1163	-100
94635	1163	-200
94646	1164	-200
94646	1164	-100

回复： How to import tab-separated text directly into tabular data with the "Import Multiple Files" function?

lala — Sun, 17 Dec 2023 10:35:30 GMT

tab

回复： How to import tab-separated text directly into tabular data with the "Import Multiple Files" function?

Craige_Hales — Sun, 17 Dec 2023 11:37:35 GMT

回复： How to import tab-separated text directly into tabular data with the "Import Multiple Files" function?

txnelson — Sun, 17 Dec 2023 12:53:16 GMT

If you remove

<<Set Import Mode( "Row Per Line" )

The file imports correctly

The proper setting, which is the default setting for csv files is

<<Set Import Mode( "CSV Data" )