It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×3,954

question asked: Nov 27 '11, 8:43 a.m.
question was seen: 6,116 times
last updated: Sep 11 '12, 11:26 a.m.

Related questions

Retaining New Line in "Primary Text" during .csv i

0
Vivek Buzruk (31●1●14●12) | asked Nov 27 '11, 8:43 a.m.
New line in Primary text is removed during import of .CSV file.

RRC version being used is 3.0.1 and 3.0.1.1

Any workaround or solution (as early as possible)?

Thanks

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Benjamin Silverman (4.1k●6●10) | answered Nov 28 '11, 12:10 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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.
0
permanent link
Pietro Mazzoleni (46●11●10) | answered Sep 11 '12, 11:26 a.m.
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

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.