Results 1 to 2 of 2
  1. #1
    Hussainkh is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2020
    Posts
    1

    Post Importing from field delimited text

    My text is:



    Record 1
    Author: Hussain
    Title: Malayalam
    Publisher: DC Books

    Record 2
    Author: Ashok
    Title: Typesetting

    Record 3
    Publisher: Sayahna
    Title: LateX
    Author: Radhakrishnan


    How these kind of data be imported to MS Access. Note that It is not necessary to contain each record the same number of fields as in Record 2. Also the order may be different as in Record 3

    Is there any special module for this in Access? Or any external Parsing program?

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    You might want to have a look at my email parser (http://forestbyte.com/ms-access-util...rser-importer/) to get some ideas. Basically you could use Split(YourText,"Record") to get the individual records then for each of those use Instr with a keyword approach to get the individual data elements. I usually look for two sequential keywords (between "Author:" and "Title:" you have the author name, etc.) but your order inconsistency will make that not working so maybe look for sequential ":".

    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 22
    Last Post: 08-09-2017, 04:18 PM
  2. Delimited text not importing correctly!! This is weird
    By memaxt in forum Import/Export Data
    Replies: 3
    Last Post: 09-04-2014, 02:45 PM
  3. Importing tab delimited files without spec
    By AndrewAfresh in forum Programming
    Replies: 4
    Last Post: 04-16-2013, 06:26 AM
  4. Importing Text Delimited
    By BLD21 in forum Import/Export Data
    Replies: 2
    Last Post: 05-06-2011, 10:23 AM
  5. Replies: 5
    Last Post: 02-20-2011, 08:22 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums