Page 1 of 1
Character Count in a field
Posted: Fri Jul 10, 2009 10:37 am
by chibbert
I have a ITEM DESCRIPTION character field that is 30 characters in length. If the description is "GUMMI BEARS", I would like to be able to count that there is 11 characters there. Basically - I have 9,000 items and I need to build a list of items where the description exceeds 25 characters in length. Is this possible?
=> RE: Character Count in a field
Posted: Fri Jul 10, 2009 12:15 pm
by Tom_Freitas_(Guest)
I am assuming that this is a database and that the name comes from a field and that this field is left justified! If the field name is description and you want to see all descriptions that are over 11 characters in length, then filter the report as follows;____len(rtrim(description)) > 11____You rtrim or right trim so that the spaces are not counted as part of the description. That way it will look at the len or length of the description up to the last character only.
==> RE: Character Count in a field
Posted: Fri Jul 10, 2009 12:52 pm
by chibbert
Your method worked great - thanks so much for your quick response.