![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: How to search and replace object text with paragraph marks Topic Summary: Created On: 29-Jul-2008 20:58 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
Here's a problem I hope will have a simple solution, but I've learned not to set my hopes too high, so if not, oh well.
I have a Word document that is a table, but I don't want it imported as a table. The table has a single column which contains text destined to be object text, and other columns containing data destined to be attributes. So far, so good. All I need to do is paste the table into Excel and then import the spreadsheet. Well, not quite. The problem is that some of the cells in Word contain paragraph marks, which forces multiple cells (and rows) into Excel. Multiple rows equal multiple DOORS objects, which I don't want. The quick and dirty way to avoid the problem going from Word to Excel is to replace the paragraph marks with some other characters (such as ~~~); now one Word cell equals one Excel cell (say that three times, fast). Imports into DOORS as nicely as can be. But, once it is in DOORS, how do I search for ~~~ and replace them with paragraph marks? ------------------------- You never know where you're going 'til you get there Edited: 29-Jul-2008 at 21:50 by David Dawson |
|
![]() |
|
![]() |
|
You need an Excel Macro:
Public Sub ReplaceCR() Selection.Cells.Replace what:="~~~", replacement:=Chr(10), _ lookat:=xlPart, searchorder:=xlByRows, MatchCase:=False, _ SearchFormat:=False, ReplaceFormat:=False End Sub Then select all the cells that you want to run the replacement on and run this macro. Bob ------------------------- Bob Mathis Robert.S.MATHIS@odot.state.or.us |
|
![]() |
|
![]() |
|
D'oh! Guess I need a little more coffee.
I was so intent on getting the Excel into DOORS that I completely forgot I could simply make the correction via code in Excel. Thanks for rousing me from my slumber. For future reference though; is there a quick and dirty way to do this in DOORS, or is it going to require a bit o' dxl? david ------------------------- You never know where you're going 'til you get there |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.