We are grabing data from one system and loading it into a new CRM system. The data are the notes on accounts.
The new system has a 4,000 character limit to their notes fields (The old system had a 8,000 character limit). I need to pull only the notes that are greater than 4,000 characters (including spaces) so we have separate those manually. What type of formula for the selection criteria would I use?
Thanks in advance.
The new system has a 4,000 character limit to their notes fields (The old system had a 8,000 character limit). I need to pull only the notes that are greater than 4,000 characters (including spaces) so we have separate those manually. What type of formula for the selection criteria would I use?
Thanks in advance.