AnsweredAssumed Answered

Delete All Text After 100 Characters in Text Field??

Question asked by osensnolf on Mar 13, 2017
Latest reply on Mar 13, 2017 by philmodjunk

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

Outcomes