• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • Last Modified:

find in access table when string contains "["

I am having trouble finding then filtering on:

sDesc
[Prof
Auto[Pro
Auto[Prof
Prof
Pro
Professional

where the string contains the "[" or "]" it wont search properly

it says the pattern string is invalid. there is no error code with this given


how do i overcome this?
0
PeterBaileyUk
Asked:
PeterBaileyUk
  • 4
  • 3
1 Solution
 
Rgonzo1971Commented:
Hi,

please try

Like "*[[]*"

Regards
0
 
PeterBaileyUkAuthor Commented:
can i do that in the cntl f find box for testing?
0
 
Rgonzo1971Commented:
I don't think so

SELECT Table1.Field
FROM Table1
WHERE Table1.Field Like "*[[]*";
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
PeterBaileyUkAuthor Commented:
can it flip the other way around for
sDesc
Med]
Med
0
 
PeterBaileyUkAuthor Commented:
what is the significance of the two closed brackets together? []
0
 
Rgonzo1971Commented:
it is the opening bracket between an opening and a closing bracket

Siehe  link

Matches any single character within the brackets.

https://support.office.com/en-US/Article/Access-wildcard-character-reference-af00c501-7972-40ee-8889-e18abaad12d1?ui=en-US&rs=en-US&ad=US

for closing bracket use

SELECT Table1.Field
FROM Table1
WHERE Table1.Field Like "*]*";
0
 
PeterBaileyUkAuthor Commented:
brilliant thx
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now