cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
lala
Level VIII

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

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

Thanks!

2023-12-17_18-27-10.png

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

2023-12-17_18-28-10.png

1 ACCEPTED SOLUTION

Accepted Solutions
Craige_Hales
Super User

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

4 REPLIES 4
lala
Level VIII

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

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
lala
Level VIII

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

tab

Craige_Hales
Super User

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

MFI.png

Craige
txnelson
Super User

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

If you remove

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

The file imports correctly

txnelson_0-1702817302830.png

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

<<Set Import Mode( "CSV Data" )
Jim