473,320 Members | 1,876 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

filtering text fields by the amount of characters

I need to filter out any records where the characters are not equal to characters. If I use "*****" that gives me all the 2, 3, and 4 character records too. How do I filter those out?
Mar 6 '15 #1
3 1031
Brilstern
208 100+
ahyland,

Not really sure what you are asking here. Can you elaborate? providing some of your code and table structure would be handy.
Mar 6 '15 #2
twinnyfo
3,653 Expert Mod 2GB
ahyland,

Do you mean you want all records that have values that are not within ASCII Characters 65-90 and 97-122 (the ASCII set of letters) or something else.

Your question is a bit unclear, as Mr. Bias has noted, and I'm not sure what you mean by 2, 3, and 4 character records. Either way, the only method I can think of doing this is to search each record (just one field or all fields???) individually, then look at each character individually for "non-characters" (again the verbiage is a bit unclear what you mean, because characters are always characters.....) and identify those records. With many records, fields, large strings, this could take a long time, but just about anything can be done.

Please provide an example of what you are looking for.
Mar 6 '15 #3
twinnyfo
3,653 Expert Mod 2GB
I just re-read the title of this post. Are you looking to exclude records that do not have a certain length (i.e. a number of characters)?

A simple method would be:

Expand|Select|Wrap|Line Numbers
  1. WHERE Len([FieldName]) <> 3
Mar 6 '15 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Roy Adams | last post by:
Hello people I've recently been woring with multiple insert from text fields and got that woking fine thanks to the help from people from this forum now i'm trying to deal with multiple update,...
4
by: Michi | last post by:
I was wondering what the best solution is for making large numbers of TEXT (or BLOB?) fields searchable. For example, if I have a forum, what is the best way to be able to search for specific...
2
by: kuhni | last post by:
Hi everybody! After searching newsgroups for a couple of hours, I now try asking directly (running the risk of asking again the same question). My problem is to predict when the size of the...
3
by: Frustrated Developer via DotNetMonster.com | last post by:
I have posted a couple times on here already and found the user community to be very helpful. I took on a project before I realized how difficult a time I'm having working with a database....
2
by: ghadley_00 | last post by:
Hi, I have a form with memo & text fields that get printed onto a report. I would like to add buttons to my form which insert one of the following symbols: ↑ ↓ ← → to a text or memo...
3
by: John Smith | last post by:
I have two text fields in a table. One is Height, one is width. Some examples of what might be each field: Height Width 35' 35' 8' 6' 4 to 6...
7
by: Tzanko | last post by:
As we all know, there is a 8060 bytes size limit on SQL Server rows. I have a table which requires a number of text fields (5 or 6). Each of these text fields should support a max of 4000...
2
by: letam | last post by:
Hello, Thank you in advance for any help, it will be most appreciated! I need to be able to disable several text fields, until the user enters a value in a certain text field. Once they enter a...
2
by: parnellsquare | last post by:
I am a software tester - the developers I am working with are telling me there is no way to allow users to enter text that includes punctuation marks like apostrophes, quate marks, semi-colons,...
0
by: =?Utf-8?B?U3BlZWR5?= | last post by:
Hi, how does one enter characters of a foreign language in a text field? In particular, I am trying to enter the s with caron on top. In Word I would type <Ctrl>+<Alt>+^ followed by the s. This...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shllpp 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.