jmerlini 发表于 2011-09-30 10:46

IQ用option选项导出数据，是否能去掉最后一列的分隔符，这里是","

导出就是这样：
"96","002","96900","00000","6839","         ","","20100107","A",
"96","002","96900","00000","6816","         ","","20100108","A",
"96","002","96900","00000","6817","         ","","20100109","A",
"05","121","05664","05662","0096","         ","","20100110","A",
"05","121","05664","05662","3891","056645001","","20100111","A",
"10","117","10474","10479","0096","         ","","20100112","A",
"10","117","10474","10479","3891","104745002","","20100113","A",
"01","102","01144","01155","0096","         ","","20100114","A",
"01","102","01144","01155","3891","011445002","","20100115","A",
"05","002","25042","05032","0096","         ","","20100116","A",
"05","002","25042","05032","0420","250420001","","20100117","A",
"08","118","08127","08123","0096","         ","","20100118","A",

andkylee 发表于 2011-09-30 13:23

你设置row delimited by "\r\n"

jmerlini 发表于 2011-09-30 14:03

回复 2# andkylee

我机器是unix-hp的
   
Parameters exdic,exfile,bdate,edate;

SET TEMPORARY OPTION Temp_Extract_Column_Delimiter = ',';
SET TEMPORARY OPTION Temp_Extract_Null_As_Empty = 'ON';
SET TEMPORARY OPTION Temp_Extract_Row_Delimiter = '\x0a';
--SET TEMPORARY OPTION Temp_Extract_Quotes_All='OFF';
SET TEMPORARY OPTION Temp_Extract_Quotes='ON';
SET TEMPORARY OPTION Temp_Extract_Quote='"';
SET TEMPORARY OPTION Temp_Extract_Name1 ='{exdic}/{exfile}';
SET TEMPORARY OPTION TEMP_EXTRACT_SIZE1 = 1073741824;


选项的具体设置这样的。
页: [1]
查看完整版本: IQ用option选项导出数据，是否能去掉最后一列的分隔符，这里是","