Results 1 to 3 of 3
  1. #1
    avandalay is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2011
    Posts
    1

    Function to Dynamically Parse Text

    I have several thousand lines of text in a form:

    Company >> Group >> Project >> etc.



    I'd like to break these lines up into separate fields for each (company, group, project, etc.). Is there a function (or suggestions to write a function) that can scan each line for the ">>" break and remove just the relevant part?

    Any alternate strategies also appreciated. Thanks.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    you have thousands of lines of text on a form, a database form? or a you have text in a text file that you want to break up and/or import into a table? is it a text file of some sort that is delimited by a single > mark or by double >> marks? I'm not really following your use of terminology. In in access a table is an object that contains data that is broken up into fields, a field is an individual piece of data. A form is a visual representation of what is held in a table. But the way you are using the term I don't think we're speaking the same language.

  3. #3
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Hmm, this is marked solved but it has no solution posted. Is it really solved (if so, please post your solution) or is it just marked that way by accident?

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

Similar Threads

  1. Replies: 0
    Last Post: 02-27-2011, 07:03 AM
  2. parse on the fly when running a query
    By johnmerlino in forum Queries
    Replies: 9
    Last Post: 11-19-2010, 10:18 PM
  3. Replies: 1
    Last Post: 08-13-2010, 01:06 AM
  4. How to validate dynamically generated text box
    By TheFuzzball in forum Forms
    Replies: 1
    Last Post: 10-24-2009, 10:49 AM
  5. Parse a File from a Directory and write data to table
    By galahad in forum Database Design
    Replies: 0
    Last Post: 04-23-2009, 08:38 AM

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