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

    Delete All Text After 100 Characters in Text Field??

    osensnolf

      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)??

       

      Thanks
      Steve