杭州交通信息网武汉pos机办理:请教有关CSV文件转成EXCEL文件的问题
来源：百度文库 编辑：杭州交通信息网 时间：2024/04/28 02:29:06
我有大量类似下面的CSV文件需要转换成EXCEL文件格式，http://前面的一段是产品名称，转换成EXCEL后第一列是产品名称 第二列是产品的网址，依次类推。因为这个CSV文件连在一起的，2个产品间没有回车，所以直接导入EXCEL时将会变的很乱。麻烦熟悉这方面的朋友告诉我怎么操作（具体步骤，最好是操作过了能用的），先谢谢了。把下面的一段复制保存为.txt文件就是我需要转换的源数据文件了。
Omega 3 Fish Oil High Strength|http://pdt.td.com/click?a=1183464&p=18798&prod=16440599|http://www.td.co.uk/goldshield/SS347.jpg|"SS346 Goldshield Omega 3 Fish Oil High Strength. Helps maintain a healthy heart and normal circulation. Provides two essential fatty acids - 180mg EPA and 210mg DHA. 365 capsules. 10000mg. Omega 3 Fish Oil is without doubt, one of the most essential supplements for people wishing to maintain overall general good health."|20.00|GBP|16440599|Health and beauty;|Health and Beauty|Size:365 capsules;Strength:1000mg;|Korean Ginseng|http://pdt.td.com/click?a=1183464&p=18798&prod=16440587|http://www.td.co.uk/goldshield/SS289.jpg|"Ginseng is highly acclaimed by many people who live active demanding lives, such as sportsmen and women. It has mild energy boosting properties."|17.50|GBP|16440587|Health and beauty;|Health and Beauty|Size:365 capsules;|Liteosan|http://pdt.td.com/click?a=1183464&p=18798&prod=16440619|http://www.td.co.uk/goldshield/GNN025.jpg|"With a new tablet has a top layer that is quickly absorbed into the body but also a secondary layer that is slowly released into the body. Liteosan contains favourites such as Chitosan, Apple Cider Vinegar, Green Tea and Dandelion Root. Start as you mean to go on"|20.00|GBP|16440619|Health and beauty;|Health and Beauty|Size:60 tablets;|Flexeze Glucosamine Hi Strength|http://pdt.td.com/click?a=1183464&p=18798&prod=16440569|http://www.td.co.uk/goldshield/SS412.jpg|"SS412 Goldshield Flexeze Glucosamine High Strength with Chondroitin. For joints, mobility and connective tissue. 60 capsules. Glucosamine 410mg and Chondroitin 100mg. Our Top Seller. A special formulation to maximise the benefits of Glucosamine, which promotes joint maintenance."|8.00|GBP|16440569|Health and beauty;|Health and Beauty|Size:60 capsules;Strength:410mg;|
Omega 3 Fish Oil High Strength|http://pdt.td.com/click?a=1183464&p=18798&prod=16440599|http://www.td.co.uk/goldshield/SS347.jpg|"SS346 Goldshield Omega 3 Fish Oil High Strength. Helps maintain a healthy heart and normal circulation. Provides two essential fatty acids - 180mg EPA and 210mg DHA. 365 capsules. 10000mg. Omega 3 Fish Oil is without doubt, one of the most essential supplements for people wishing to maintain overall general good health."|20.00|GBP|16440599|Health and beauty;|Health and Beauty|Size:365 capsules;Strength:1000mg;|Korean Ginseng|http://pdt.td.com/click?a=1183464&p=18798&prod=16440587|http://www.td.co.uk/goldshield/SS289.jpg|"Ginseng is highly acclaimed by many people who live active demanding lives, such as sportsmen and women. It has mild energy boosting properties."|17.50|GBP|16440587|Health and beauty;|Health and Beauty|Size:365 capsules;|Liteosan|http://pdt.td.com/click?a=1183464&p=18798&prod=16440619|http://www.td.co.uk/goldshield/GNN025.jpg|"With a new tablet has a top layer that is quickly absorbed into the body but also a secondary layer that is slowly released into the body. Liteosan contains favourites such as Chitosan, Apple Cider Vinegar, Green Tea and Dandelion Root. Start as you mean to go on"|20.00|GBP|16440619|Health and beauty;|Health and Beauty|Size:60 tablets;|Flexeze Glucosamine Hi Strength|http://pdt.td.com/click?a=1183464&p=18798&prod=16440569|http://www.td.co.uk/goldshield/SS412.jpg|"SS412 Goldshield Flexeze Glucosamine High Strength with Chondroitin. For joints, mobility and connective tissue. 60 capsules. Glucosamine 410mg and Chondroitin 100mg. Our Top Seller. A special formulation to maximise the benefits of Glucosamine, which promotes joint maintenance."|8.00|GBP|16440569|Health and beauty;|Health and Beauty|Size:60 capsules;Strength:410mg;|