39286_zh-CN

liliconcom

如何在通过脚本连接文件之前获取导入文件设置？

我有几个特定格式的文件，并带有 *.asc 扩展名（例如：本文附加的两个文件）。 我试图对 Bryan 上传的脚本进行更改，可以在这里找到： https://community.jmp.com/t5/JMP-Scripts/Combine-multiple-txt-or-csv-files/ta-p/24083

 

如果我在运行脚本之前将所有文件重命名为 *.txt 效果很好，但其他情况不会。 我试图对下面的脚本进行更改（来自 Bryan），但仍然无法使其正常工作。

 

谁能帮我在脚本中获得正确的 mport 文件设置和 *.asc 过滤器？

 

谢谢

 

Re: 如何在通过脚本连接文件之前获取导入文件设置？

您可以使用 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" )
 )
)