+ Reply to Thread
Results 1 to 2 of 2

Importing and Sorting Text Database

  1. #1
    Registered User
    Join Date
    01-10-2012
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    3

    Importing and Sorting Text Database

    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

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Importing and Sorting Text Database

    Hi J_Barner
    is the data from a Text or txt file?
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1