I have imported a csv into notes that had \n for line feed expecting them to actually break the line but they appear in the note.
What can I replace them with via database update to actually line break.
Any help much appreciated.
You can test this line in your development instance:
UPDATE accounts SET description=REPLACE(description,'\\n','\r\n');
This is for accounts.description field.
For more information about replace have a look at MySQL :: MySQL 5.5 Reference Manual :: 12.5 String Functions.
Hope this helps
Best RegardsTevfik TümerDeveloper Support Engineer
Retrieving data ...