0

Is it possible to have a filter expression for character count?

Hi there,

Is it possible to have a filter expression for character count?

 

In my database I want to filter the view of a colum with "marketing manager" and limit the search to not include results with "business marketing manager".

 

So is there a way to force the result based on character count so it will only return results with the correct amount of characters?

 

Ashley

2 replies

null
    • John_Halls
    • 3 yrs ago
    • Reported - view

    Yes you *can*, by creating a formula field with the code length('Field 1'). Show this as a column and filter for 17.

    I'd be looking for a better solution than this though. Can your Marketing Manager field be put into a field of type choice, then you can filter directly on this field. This has the added benefit of easier and more accuurate data entry too.

    Regards

    John

    • Alain_Fontaine
    • 3 yrs ago
    • Reported - view

    Did you try to put: ="marketing manager" into the filter field?

Login to reply

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 410Views