text importer

[zcy]

I import file text, but in the 'result preview' don't display the data.

the follow data:

71,15,tsinghualh,tsinghualh,北京清华力合电子技术有限公司,Tsinghua Lihe Electronic Tech，Co.，LTD,清华力合,633706900,1.10E+12,F-1852020031281539500.jpg,Y-1135020031281539501.jpg,1.10E+14,1.10E+17,冯冠平,1.10E+ 14,服务， 开发， 代理， 集成， 工程,有限责任,1998-7-23,,2000,人民币,65,9200,北京市商业银行清华园& #25903;行,6001201053363-78,北京市海淀区清华大学东区,010-62792351-56,010-62773306,北京&#240 66;清华大学84-8信箱,100084,sales@tsinghua-lh.com.cn,马立新,13501365178,曾丽,13911701744,http://www.tsinghua-lh.cn, 有,北京-北京,18,三星等离子电视、三星液晶电视,2003-12-2,n,2004-2-4, ,,,撤消代理权,2004-12-20
72,16,wangjiancheng,123456,北京路通天虹商贸有限公司,,路通天虹,63361440-8,1.10E+12,F- 1920620031211141240.jpg,Y-1135020031211141241.jpg,1.10E+14,1.10E+17,王建成,1.10E+14,贸易,有限责任,1997-4-16,,688,人&#276 65;币,42,6294.87,北京市商业银行双榆树支行,1.20E+11,北京市海淀区&#2 8023;淀南路19号时代网络大厦一层2号,010-82666666,010-62533238,北京市海淀& #21306;海淀南路19号时代网络大厦一层2号,100081,lutong@ltth.com.cn,王建成,139011 35513,刘芳,13661196895,http://www.ltth.com,无,北京-北京,15,,2003-12-3,y,2004-2-3,,,,,,,,,

 

[ScottMattes]

without the table definition it would be hard to correctly guess the problem

 

[Marco Kalter]

I tried the above file, and the auto-detection is indeed not able to handle this. You can still enter the configuration by hand though. If you select the comma as end character and increment the number of fields you will see the correct data in the display area.