Skip to main content
Question

Importing data with Line breaks

  • 7 February 2024
  • 0 replies
  • 87 views

sangland
Varsity I
Forum|alt.badge.img

Hi, I have data on spreadsheet to import into Notes field where there should be multiple lines in the note. The data contains \r\n characters which are correct characters to use when importing data. However the characters appear to be stripped during import. The workaround is to alter the data in the spreadsheet replacing \r\n with CrLf (just some other text), then in the Import formulae Replace(<text>,’CrLf’,’\r\n’) which then imports as expected. Does this make sense to have to do this ?

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings