Hi
How can I select records that have non-alphanumeric characters in a field
using a select query?
Thanks
Regards 12 17156
"John" <Jo**@nospam.in fovis.co.uk> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl Hi
How can I select records that have non-alphanumeric characters in a field using a select query?
WHERE [SomeField] Like "*[!0-9A-Z]*"
--
Dirk Goldgar, MS Access MVP www.datagnostics.com
(please reply to the newsgroup)
Any way to exclude - (hyphen) from selection?
Thanks
Regards
"Dirk Goldgar" <dg@NOdataSPAMg nostics.com> wrote in message
news:OK******** *****@TK2MSFTNG P11.phx.gbl... "John" <Jo**@nospam.in fovis.co.uk> wrote in message news:%2******** ********@TK2MSF TNGP09.phx.gbl Hi
How can I select records that have non-alphanumeric characters in a field using a select query?
WHERE [SomeField] Like "*[!0-9A-Z]*"
-- Dirk Goldgar, MS Access MVP www.datagnostics.com
(please reply to the newsgroup)
Any way to use ! (literally) and {space} in the filter?
Many Thanks
Regards
"Dirk Goldgar" <dg@NOdataSPAMg nostics.com> wrote in message
news:OK******** *****@TK2MSFTNG P11.phx.gbl... "John" <Jo**@nospam.in fovis.co.uk> wrote in message news:%2******** ********@TK2MSF TNGP09.phx.gbl Hi
How can I select records that have non-alphanumeric characters in a field using a select query?
WHERE [SomeField] Like "*[!0-9A-Z]*"
-- Dirk Goldgar, MS Access MVP www.datagnostics.com
(please reply to the newsgroup)
John wrote: How can I select records that have non-alphanumeric characters in a field using a select query?
Set the field's criteria to:
Like "*[!a-z0-9]*"
--
Marsh
MVP [MS Access]
Any idea how I can include {space}, ! (literally) and - (hyphen) in the
criteria as well?
Thanks
Regards
"Marshall Barton" <ma*********@wo wway.com> wrote in message
news:ph******** *************** *********@4ax.c om... John wrote:How can I select records that have non-alphanumeric characters in a field using a select query?
Set the field's criteria to:
Like "*[!a-z0-9]*"
-- Marsh MVP [MS Access]
! matches itself anywhere except at the start of the [...] character
class.
- matches itself if it is the first or last character in the class (or
the first character after a negating !
a space matches itself in the usual way.
See VBA help on the Like Operator for more.
On Sun, 22 Jan 2006 05:26:20 -0000, "John" <Jo**@nospam.in fovis.co.uk>
wrote: Any way to use ! (literally) and {space} in the filter?
Many Thanks
Regards
"Dirk Goldgar" <dg@NOdataSPAMg nostics.com> wrote in message news:OK******* ******@TK2MSFTN GP11.phx.gbl... "John" <Jo**@nospam.in fovis.co.uk> wrote in message news:%2******** ********@TK2MSF TNGP09.phx.gbl Hi
How can I select records that have non-alphanumeric characters in a field using a select query?
WHERE [SomeField] Like "*[!0-9A-Z]*"
-- Dirk Goldgar, MS Access MVP www.datagnostics.com
(please reply to the newsgroup)
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
Dear John:
I strongly recommend you read the online help section on LIKE. It tells you
all about this. Then you'll know just how to do it.
Tom Ellison
"John" <Jo**@nospam.in fovis.co.uk> wrote in message
news:ul******** ******@TK2MSFTN GP12.phx.gbl... Any idea how I can include {space}, ! (literally) and - (hyphen) in the criteria as well?
Thanks
Regards
"Marshall Barton" <ma*********@wo wway.com> wrote in message news:ph******** *************** *********@4ax.c om... John wrote:How can I select records that have non-alphanumeric characters in a field using a select query?
Set the field's criteria to:
Like "*[!a-z0-9]*"
-- Marsh MVP [MS Access]
Thanks. I am now using; Like "*[!-!0-9A-Z &,.@/'():+]*" but it is also
excluding all accented characters. Is there a way that accented characters
are not included in this filter?
Thank again.
Regards
"John Nurick" <j.************ *@dial.pipex.co m> wrote in message
news:jv******** *************** *********@4ax.c om... ! matches itself anywhere except at the start of the [...] character class. - matches itself if it is the first or last character in the class (or the first character after a negating ! a space matches itself in the usual way.
See VBA help on the Like Operator for more.
On Sun, 22 Jan 2006 05:26:20 -0000, "John" <Jo**@nospam.in fovis.co.uk> wrote:
Any way to use ! (literally) and {space} in the filter?
Many Thanks
Regards
"Dirk Goldgar" <dg@NOdataSPAMg nostics.com> wrote in message news:OK****** *******@TK2MSFT NGP11.phx.gbl.. . "John" <Jo**@nospam.in fovis.co.uk> wrote in message news:%2******** ********@TK2MSF TNGP09.phx.gbl Hi
How can I select records that have non-alphanumeric characters in a field using a select query?
WHERE [SomeField] Like "*[!0-9A-Z]*"
-- Dirk Goldgar, MS Access MVP www.datagnostics.com
(please reply to the newsgroup)
-- John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
This is addressed in the help article I referred you to.
On Sun, 22 Jan 2006 19:12:39 -0000, "John" <Jo**@nospam.in fovis.co.uk>
wrote: Thanks. I am now using; Like "*[!-!0-9A-Z &,.@/'():+]*" but it is also excluding all accented characters. Is there a way that accented characters are not included in this filter?
Thank again.
Regards
"John Nurick" <j.************ *@dial.pipex.co m> wrote in message news:jv******* *************** **********@4ax. com...! matches itself anywhere except at the start of the [...] character class. - matches itself if it is the first or last character in the class (or the first character after a negating ! a space matches itself in the usual way.
See VBA help on the Like Operator for more.
On Sun, 22 Jan 2006 05:26:20 -0000, "John" <Jo**@nospam.in fovis.co.uk> wrote:
Any way to use ! (literally) and {space} in the filter?
Many Thanks
Regards
"Dirk Goldgar" <dg@NOdataSPAMg nostics.com> wrote in message news:OK***** ********@TK2MSF TNGP11.phx.gbl. .. "John" <Jo**@nospam.in fovis.co.uk> wrote in message news:%2******** ********@TK2MSF TNGP09.phx.gbl > Hi > > How can I select records that have non-alphanumeric characters in a > field using a select query?
WHERE [SomeField] Like "*[!0-9A-Z]*"
-- Dirk Goldgar, MS Access MVP www.datagnostics.com
(please reply to the newsgroup)
-- John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Oren |
last post by:
Hi,
Is there any way that calls to sp_addrolemember and sp_droprolemember
can be enabled for non database owners and non sysadmin members?
This would be very helpful for an application I'm in the middle of
developing, in which users have the right to view some data and edit
some data in a set of tables. The data is pulled up in a set of views
(using SQL Server 7 with an Access 2000 front-end). Depending on an
initial selection that...
|
by: Erik Max Francis |
last post by:
I was interesting in adding selection and hit testing to ZOE, and was
looking at the PyOpenGL wrappers' handling of selection and picking. I
see glSelectBuffer to specify the size of the buffer, and glRenderMode
properly returns the number of hits when put back into GL_RENDER mode,
but I don't see any way within PyOpenGL itself to access the select
buffer to actually process the hits. Is there any way to do this
without using...
|
by: Hector |
last post by:
I have a ComboBox set up in a non-modal form. When a selection is made from the ComboBox, the handler code closes the form, but then the system crashes because of an unhandled NullReferenceException. There is a reference to Unsafe Native Methods and Callback functions, but Interop Services are not used. What is going on ? The problem does not occur if the form is made modal. Any thoughts would be appreciated. The code appears below for a simple...
|
by: Andrew |
last post by:
I get a Null Reference Exception if I close a non-modal dialog (that is, a
form opened with Show()) when a selection is made from a ComboBox. The error
message refers to Unsafe Native Methods, but the code is 100% managed. The
exception is not thrown if the dialog was modal (opened with ShowDialog()) or
if the selection is made from, say, a ListBox.
I have included a simple example below.
I am using C#.NET 2003, Standard Edition.
|
by: Paul |
last post by:
Hi
I have a page broken into two sections, the first top section is selection
criteria for my datagrid. The second section is the actual datagrid. I
would like the selection criteria section to stay on the page at all times
when scrolling.
I know this can be done with frames, but I believe using frames with asp.net
is a big pain, is there another way to have a non-scrolling section on a
page?
| |
by: Michel Lapointe |
last post by:
Hello,
I would like to know if there is an event for the Datagridview control
that is trigger before the selection change and is cancelable.
I'm currently using the SelectionChanged event (using Full Row Select),
but this event is trigger only after the selection changed is completed and
therefore is non cancelable unless you keep the previous selection in a
variable and rechange the selection, which is painful.
|
by: Xah Lee |
last post by:
Of interest:
• The Semicolon Wars, by Brian Hayes. 2006.
http://www.americanscientist.org/template/AssetDetail/assetid/51982
in conjunction to this article, i recommend:
• Software Needs Philosophers, by Steve Yegge, 2006
http://xahlee.org/Periodic_dosage_dir/_p/software_phil.html
|
by: Giovanni Bajo |
last post by:
Hello,
I just read this mail by Brett Cannon:
http://mail.python.org/pipermail/python-dev/2006-October/069139.html
where the "PSF infrastracture committee", after weeks of evaluation, recommends
using a non open source tracker (called JIRA - never heard before of course)
for Python itself.
Does this smell "Bitkeeper fiasco" to anyone else than me?
--
|
by: ivowel |
last post by:
Dear Experts: I am trying to write a css style that makes text
invisible; visible-when-selected (so that at least a visible block
appears over the selected text---like black foreground over black
background with 50% opacity to make it gray and shine through what is
behind it). Similarly, I want to be able to shows links as blocks
(like red on red with opacity 20%).
I am trying firefox 1.5.0.9 and konqueror 3.5.5. I presume the...
|
by: sialater |
last post by:
Hello,
I realise there are a lot of topics related to this problem but many of what I have found has run cold or unresolved. What I have is an addressbook clone where there are groups which have members. I have this formatted in a way where the groups are in a drop down box. Once a group is selected, the two selection boxes below are refreshed with those who are members or non members of the selected group. The user has the ability to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |