476908_zh-CN

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;

回复：如何在单独的表达式中存储 Open() 函数的导入设置

我想我必须多次说明 Open() 函数。或者尝试使用 Eval Insert()

回复：如何在单独的表达式中存储 Open() 函数的导入设置

您也许可以使用这里提到的技术来做一些事情，您可以在不将表达式写为字符串的情况下构造它吗？

Names Default To Here(1);

open_expr = Expr(Open(filePath));

settings1 = Expr(
	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")
	)
);

Insert Into(open_expr, NameExpr(settings1));
Name Expr(open_expr);