8 Replies Latest reply on Mar 13, 2017 6:35 PM by philmodjunk

    Delete All Text After 100 Characters in Text Field??


      I have a text field in my database that contains keywords associated with each company.  Some companies went overboard.  How can I delete all text that after 100 characters (counting spaces and any other characters).


      Is there a way to find records that have more than 100 characters in my field?


      I searched but all I found was setting a limit on the field (which I assume only works for new and not existing data)??