VFP 愛用者社區

[ahat]

怎样FILE.DBF文件导出成下面格式的文本文件

1|AAAAAA|MALE|100.00|120.00|349.00|
2|BBBBBB|MALE|100.00|120.00|349.00|
3|CCCCC|MALE|100.00|120.00|349.00|
4|DDDDD|MALE|100.00|120.00|349.00|
5|EEEEEEE|MALE|100.00|120.00|349.00|
6|FFFFFFFF|MALE|100.00|120.00|349.00|

[bin1x]

copy to
Syntax

COPY TO FileName
[DATABASE DatabaseName [NAME LongTableName]]
[FIELDS FieldList
| FIELDS LIKE Skeleton
| FIELDS EXCEPT Skeleton]
[Scope] [FOR lExpression1] [WHILE lExpression2]
[[WITH] CDX] | [[WITH] PRODUCTION]
[NOOPTIMIZE]
[[TYPE] [FOXPLUS | FOX2X | DIF | MOD
| SDF | SYLK | WK1 | WKS | WR1 | WRK | XLS | XL5
| DELIMITED [WITH Delimiter | WITH BLANK | WITH TAB
| WITH CHARACTER Delimiter]]]
[AS nCodePage]
with character delimiter 應該就可以了 delimiter 換成"|"
沒做過,但應該這樣就行了

[ahat]

|1|AAAAAA|MALE|100.00|120.00|349.00
|2|BBBBBB|MALE|100.00|120.00|349.00
|3|CCCCC|MALE|100.00|120.00|349.00
|4|DDDDD|MALE|100.00|120.00|349.00
|5|EEEEEEE|MALE|100.00|120.00|349.00
|6|FFFFFFFF|MALE|100.00|120.00|349.00

我就按哪个命令输出之后上面格式呀

[小賴]

copy to filename.txt delimited with "" with character "|"

[ahat]

我用上面命令最后列后面没有"|" 分隔符呀

[bin1x]

不然就用大爛招
use table
set print on
set print to file1
scan
? field1 .....
?? "|"
.......
XXXXXX
........
XXXXXX
end scan
set print to
set print off

[小賴]

最後一行多出 "|" 字元可能因為原來之資料表格
最後欄位格式為"通用欄位" (General) 或 "備註欄位"(MEMO)
造成 ; 實測如下


無MEMO格式欄位之情況
00002|吳廷 X|06-3124233|01/01/1974|42000
00003|陳X葉|06-2257923|10/01/1975|42000
00014|X秀英|06-2154702|08/01/1985|27600
00029|賴XX|06-2668437|07/01/1992|42000
00165|呂XX|06-2143521|01/01/2005|16500

最後欄位為MEMO格式時之情況
00002|吳廷X|06-3124233|01/01/1974|42000|
00003|陳X葉|06-2257923|10/01/1975|42000|
00014|X秀英|06-2154702|08/01/1985|27600|
00029|賴XX|06-2668437|07/01/1992|42000|
00165|呂XX|06-2143521|01/01/2005|16500|