当某一字段出现字符分隔符号" (也许是其他符号)
而之前字段为空--也就是有多个字段分隔符连续
则此字段内容之前无论多少分隔符号在导入时都被视作1个
如:
(文本中的1行)
Smith 9999999 "TELEPHONE"
telephone前有 3 tab
appe from t.txt deli with char tab
导入时三字段是紧挨的
| Smith | 9999999 | TELEPHONE | ||
appe from t.txt deli with char tab
appe from t.txt deli with tab
appe from t.txt deli with '"' with char tab
appe from t.txt deli with tab with char '"'
appe from t.txt deli with ' ' with char '"'
appe from t.txt deli with " with char tab
这就只能解释为VFP命令的问题了
最安全的导入方式
appe from t.txt deli with "" with char tab
551



被折叠的 条评论
为什么被折叠?



