Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: CSV export of numerical data column & line breaks
Topic Summary:
Created On: 1-Jul-2008 18:03
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 1-Jul-2008 18:03
User is offline View Users Profile Print this message


Rich Mason

Posts: 26
Joined: 11-Apr-2007

I've got an Absolute number column that when exported to CSV provides a "block" like character as a line break in Excel between the abs nums as the line break character.

Anybody know how to get rid of this in Excel? I haven't found the character in Excel's find & replace to get rid of it. Alt+0010 doesn't work b/c Excel isn't reading the block character as a line break.

I'm aware about how to get into word and do away with, but problem with that is pasting back into excel reads all the line breaks as new cells, rather line multiple lines of abs nums in one cell.

thanks

-------------------------
Rich Mason
richard_mason@drsoptronics.com
Report this to a Moderator Report this to a Moderator
 27-Oct-2008 12:58
User is offline View Users Profile Print this message


Kevin Murphy

Posts: 120
Joined: 16-Jan-2008

I am getting the same thing too with CSV exports in DOORS 8.3. I don't recall getting this block character before. This even happens upon writing a custom CSV exporter.

Does anyone know why this is happening and how to fix it? I'm doing some research on it now. DOORS 9.0 exhibits the same behavior with Excel 2003.

-------------------------
Kevin Murphy
http://www.baselinesinc.com
Report this to a Moderator Report this to a Moderator
 27-Oct-2008 13:16
User is offline View Users Profile Print this message


Kevin Murphy

Posts: 120
Joined: 16-Jan-2008

I'm still not sure why DOORS/Excel is doing this, but do have a fix.

The "square" is character code 13.

You can run this code in VBA to fix this:

Cells.Replace What:=Chr(13), Replacement:="", lookat:=xlPart, SearchOrder:=xlByColumns

-------------------------
Kevin Murphy
http://www.baselinesinc.com
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.