476908_zh-TW

liliconcom

如何將 Open() 函數的導入設置存儲在單獨的表達式中

我需要使用各種設置打開 CSV 文件。

示例之一如下：

dt = Open(
 filePath,
 Import Settings(
  End Of Line( CRLF, CR, LF ),
  End Of Field( Comma, 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( 18 ),
  Data Starts( 19 ),
  Lines To Read( "All" ),
  Year Rule( "20xx" )
 )
);

我想將 Import Settings() 構造中的這些設置存儲為單獨的表達式，然後在打開文件時使用它。

像這樣的東西（但它顯然不是這樣工作的）：

settings1 = Expr(
Import Settings(
<MY import="" settings="" here="">
)
);
settings2 = Expr(
Import Settings(
<SOME other="" import="" settings="" here="">
)
);

if(condition, importSettings = settings1, importSettings = settings2)
dt = Open(
filePath, 
Eval(importSettings)
);</SOME></MY>

腳本回复：如何將 Open() 函數的導入設置存儲在單獨的表達式中

一種選擇可能是像這樣包裝它們：

Names Default To Here(1);

settings1 = Expr(
 dt = Open(
  filePath,
  Import Settings(
   End Of Line(CRLF, CR, LF),
   End Of Field(Comma, 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")
  )
 )
);


settings2 = Expr(
 dt = Open(
  filePath,
  Import Settings(
   End Of Line(CRLF, CR, LF),
   End Of Field(Comma, 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(5),
   Data Starts(6),
   Lines To Read("All"),
   Year Rule("20xx")
  )
 )
);

filePath = "somefilehere";
settings1;
settings2;