39286_zh-TW

liliconcom

如何在通過腳本連接文件之前正確獲取導入文件設置？

我有幾個特定格式的文件，擴展名為 *.asc（例如：本文所附的兩個文件）。 我試圖對 Bryan 上傳的腳本進行更改，可以在這裡找到： https://community.jmp.com/t5/JMP-Scripts/Combine-multiple-txt-or-csv-files/ta-p/24083

 

如果我在運行腳本之前將所有文件重命名為 *.txt，效果會很好，但其他情況不會。 我試圖對下面的腳本進行更改（來自 Bryan），但仍然無法正常工作。

 

誰能幫我在腳本中獲得正確的 mport 文件設置和 *.asc 過濾器？

 

謝謝

 

回复：如何在通過腳本連接文件之前正確獲取導入文件設置？

您可以使用 open("filename.asc","text") 讓 JMP 假設該文件是要導入的數據文本文件。 通過預覽嚮導導入後，我從表格中取出了這個腳本。 由於它有其他選項，因此不需要“文本”。 在文件打開對話框中，將過濾器設置為 *.*，選擇您的文件，然後將過濾器設置為 *.txt 並選擇預覽嚮導。 查看導入表的源腳本以查找...

Open(
 "C:\Users\...\Desktop\Example01.asc",
 columns(
  New Column( "Column 1", Character, "Nominal" ),
  New Column( "0s", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "90s", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "180s", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "270s", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "360s", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "450s", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "540s", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "630s", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "720s", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "810s", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "900s", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "990s", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "1080s", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "1170s", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "1260s", Character, "Nominal" ),
  New Column( "1350s", Character, "Nominal" ),
  New Column( "1440s", Character, "Nominal" ),
  New Column( "1530s", Character, "Nominal" ),
  New Column( "1620s", Character, "Nominal" ),
  New Column( "1710s", Character, "Nominal" ),
  Omitted Column( . )
 ),
 Import Settings(
  End Of Line( CRLF, CR, LF ),
  End Of Field( Tab, CSV( 0 ) ),
  Strip Quotes( 1 ),
  Use Apostrophe as Quotation Mark( 0 ),
  Use Regional Settings( 0 ),
  Scan Whole File( 1 ),
  Treat empty columns as numeric( 0 ),
  CompressNumericColumns( 0 ),
  CompressCharacterColumns( 0 ),
  CompressAllowListCheck( 0 ),
  Labels( 1 ),
  Column Names Start( 1 ),
  Data Starts( 2 ),
  Lines To Read( "All" ),
  Year Rule( "20xx" )
 )
)