Results 1 to 2 of 2
  1. #1
    tuna is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2010
    Posts
    21

    String Matching


    Hi, is there any function that can find a string and return the match while also supporting the use of wildcards in the needle expression (essentially a vba equivalent of regex.match)? e.g. for such a function named StrMatch, StrMatch("Haystack", "s*") would return "stack"

    Thanks

  2. #2
    Join Date
    May 2010
    Posts
    339
    Hi Tuna,

    Does it have to be a Function? A parameter query could display the same matches.

    Example 1: Like [Example area code 1952] & "*" this would find all area codes that starts with 1952.

    Example 2: Like "*" [Example area code 1952] & "*" this would find 1952 in any part of the string.


    Richard

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

Similar Threads

  1. Join queries that do not have matching field
    By Petefured in forum Queries
    Replies: 2
    Last Post: 05-04-2010, 11:19 AM
  2. Comparing Dates And Matching Quantities
    By chrisleng in forum Programming
    Replies: 0
    Last Post: 02-23-2010, 10:50 AM
  3. Matching Query Dates
    By rgwynne in forum Queries
    Replies: 1
    Last Post: 08-13-2009, 05:23 AM
  4. Display Non Matching Data
    By k1fox in forum Access
    Replies: 1
    Last Post: 04-03-2009, 07:18 PM
  5. Partial Matching based Queries
    By Yatesb in forum Queries
    Replies: 0
    Last Post: 02-23-2009, 01:06 PM

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