STRING LENGHT

[Guest]

Is there any possibility to sort a column in Access by string lenght, or
filter all longer than 30 characters?

 

[Douglas J Steele]

Sure.

Create a query, and add as many fields from the table as you care about.

Add a computed field by typing something like the following into a blank
cell on the Field row in the query builder:

StringLength: Len([MyTextField])

(replace "MyTextField" with the name of the actual field)

To sort by string length, select either Descending or Ascending in the Sort
row underneath the computed field you just added.

Not sure if by "filter all longer than 30 characters" you mean you only want
to see those that are longer than 30 characters, or you want to eliminate
those that are longer than 30 characters. For the former, put > 30 in the
Criteria row under the computed field you just added. For the former, put <=
30 as the Criteria.

By the way, if you uncheck the "Show" box under the computed field you just
added, you won't see the field length in the query results, but the sorting
and filtering will still work.

 

[Rick B]

To sort it by this, add a new column of =Len([field name])
then sort by it.

 

[Pieter Wijnen]

SELECT ..., Len(Thefield) AS LenOfField FROM ...
[WHERE Len(Thefield) > 30]
ORDER BY LenOfField

Pieter

 

[Rick B]

oops. forget the "="

In a query it would be more like...

NewField: Len([CurrentField])


--
Rick B

To sort it by this, add a new column of =Len([field name])
then sort by it.

--
Rick B

Is there any possibility to sort a column in Access by string lenght, or
filter all longer than 30 characters?