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 ?
Solved
Importing data with Line breaks
Best answer by KrunalDoshi
Hi
I think the workaround what you have is the best solution considering the Excel file you have. I believe, instead if you have CSV then I think it will import as per your requirements.
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 ?
Hi there
not sure if you found a solution but this works for me:
CStr('\r\n')
[Column1]+CStr('\r\n')+[Column2] etc.
Translate
+9Hi
I think the workaround what you have is the best solution considering the Excel file you have. I believe, instead if you have CSV then I think it will import as per your requirements.
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.