I have a CSV file of Tasks (activity) to upload. As it can be seen from the picture below that the line breaks are occurring, how can I format such a file in excel, because the data loader or any CSV tool will see the line break a new row / record in the CSV.
Data source has line breaks, but I want to import those through Data Loader.
- Export the data but change the Char(10), Char(13) values to a unique text value like "!!!" with a replace function: ie Replace (Textfield, CHAR(10), '!!!"). This will remove the line breaks, but put place holders in place instead.
- Import the Data into Exel.
- On that column, do a Find Replace: Find: !!! Replace: "CtRL" + "J". This will put line breaks in your field, but will keep the text together.
- Save as CSV and Import via Data Loader.