Retaining New Line in "Primary Text" during .csv i
2 answers
We've recently filed a defect for this here. Unfortunately I did not find any workarounds other than updating the requirement manually in the editor after the text was imported on the same line.
Have you tried to replace "LF" (added by default in Excel) with "CRLF"?
In excel,
(A) I select the column containing the primary text (with "LF" on it)
(B) Run the following macro
Sub ReplaceLfWithCrLfs()
Dim ArtifactCell As Range
Dim TempPrimaryText As String
For Each ArtifactCell In Selection
TempPrimaryText = ArtifactCell.Text
Do While InStr(TempPrimaryText, vbLf) > 0
TempPrimaryText = Replace$(TempPrimaryText, vbLf, "XYX@kk")
Loop
Do While InStr(TempPrimaryText, "XYX@kk") > 0
TempPrimaryText = Replace$(TempPrimaryText, "XYX@kk", vbCrLf)
Loop
ArtifactCell.Value = TempPrimaryText
Next
End Sub
(C) Export to CSV and import into RRC
In excel,
(A) I select the column containing the primary text (with "LF" on it)
(B) Run the following macro
Sub ReplaceLfWithCrLfs()
Dim ArtifactCell As Range
Dim TempPrimaryText As String
For Each ArtifactCell In Selection
TempPrimaryText = ArtifactCell.Text
Do While InStr(TempPrimaryText, vbLf) > 0
TempPrimaryText = Replace$(TempPrimaryText, vbLf, "XYX@kk")
Loop
Do While InStr(TempPrimaryText, "XYX@kk") > 0
TempPrimaryText = Replace$(TempPrimaryText, "XYX@kk", vbCrLf)
Loop
ArtifactCell.Value = TempPrimaryText
Next
End Sub
(C) Export to CSV and import into RRC