Preserving carriage returns in item descriptions when transitioning from a legacy system to NetSuite can be tricky. Below are the steps I use to accomplish this.

  1. Export the data to a CSV from the legacy system with a special character like the pipe or a tilde indicating carriage returns
  2. Do any data scrubbing / alterations that need to be done in preparation for import
  3. Do a find and replace for the special character. You will want to replace the special character with Ctrl+J
  4. Import to NetSuite

Note: that it is important to do the find and replace in step three as the last data transformation. Doing more transformations after may risk losing the carriage returns.

Need help with NetSuite? We can help! Learn more about our NetSuite services, schedule a free consultation, or call us at (212) 869-9300. 

Wait! Before You GoWould you like to talk to a business software expert to answer your questions?

When you schedule a free consultation with MIBAR, you will experience a one-on-one conversation with a business technology expert who is passionate about understanding your unique needs or issues. Schedule a free consultation today at the link below or give us a call at (212) 869-9300.

Learn More