Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    4

    Unanswered: Get specific data out of a memo field in a table

    I have some data in a stored in a memo field in a table, for example:

    Name: Jim Smith
    Email: jim@domain.com
    Tel: 00012358555

    Date: 23/3/02
    How would I go about going making an array which will loop through each line of the data stored, so that I pick up specific data???

    Thanks

  2. #2
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile Re: Get specific data out of a memo field in a table

    Originally posted by wavp
    I have some data in a stored in a memo field in a table, for example:



    How would I go about going making an array which will loop through each line of the data stored, so that I pick up specific data???

    Thanks
    For memo fields, I've generally had to use string manipulation code to find things. One technique that I have used is to move through the text one word at a time looking for spaces, periods, line feed and carriage returns to help identify words and sentences. Then I add them to a collection or an array, as you mentioned, one word at a time. There are also other characters that you want to exclude from being part of a word such as commas and colens etc.
    If you have a particular character such as the "@" in an Email address that you are looking for it gets a bit easier by using the InStr function and then just identify the spaces before and after the address to locate your word.

    Having said all that, are you looking for code to do something like this or just syntax and language help with arrays?

    Gregg

  3. #3
    Join Date
    Feb 2004
    Posts
    16

    similar problem

    I have a similar problem:

    I have a memo field that contains a large string of text with newline chars at the end of each line.
    I am trying to figure out a way to analyze that string line by line.

    for example:
    one line might tell me that there was a miscount in the number of cartons, tell me the old number (54) and then tell me the number was corrected to (56).

    I would like to be able to say something along these lines:
    Search the string for a count of the number of times the word "carton" was found.
    Because of the uniformity of the way the strings are brought into the memo field I know that the word "carton" for a typical error would be displayed twice - therefore I can take the count of the number of times "carton" was found, divide it by 2, and know the number of carton errors I had.

    I understand code fairly well, but have not worked with it in a couple years so I do not know the best approach to take within access to accomplish this. I was thinking there would be some way to build an expression in the expression builder or a macro or module?? Also what is the common language used to interact with Access - VB? or can I use one of a few different languages?

    Thanks for the help!

Posting Permissions

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