![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
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 |
![]() |
![]()
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.