I imported a database from a text file that is formatted like the example below (with field tags in first column and data in second column):
Member Name: Zhuhai Liri Tent Technology Co Ltd
Contact: Adam Yuhonglin
Address: No 7 Dongfu Rd, Xin Qing Ind. Zone
City State Zip Doumen Zhuhai City, China
Phone: +0086 756 5211007
Fax: +0086 756 5311018
Email: [email protected]
Web site: www.liri-tents.com
Member Name: Zebec Inc.
Contact: Ed Snyder
Address: PO Box 18031
City State Zip Fairfield, OH 45018-0031
Phone: (513) 829-5533
Fax: (513) 892-7466
Member Name: Yamaten Co. Ltd.
Contact: Manabu Shimamaki
Address: 4-23, 5 Chome, Tsurumi
Address2: Tsurumi-ku
City State Zip Osaka, 538-0053 Japan
Phone: +81 6 6911 7400
Fax: +81 6 6911 7778
Email: [email protected]
Web site: www.yamaten.com
There is no consistancy with number of field tags.
Any suggestions on how to convert to sortable data? Too much data to do so manually. THANKS
Bookmarks