Odd spacing for eaXL exports

This topic has 2 replies, 2 voices, and was last updated 6 years, 9 months ago by Dina O’Donnell.

Viewing 3 posts - 1 through 3 (of 3 total)

Author

Posts
9 January 2018 at 8:59 pm #9149

Dina O’Donnell
Participant

Hi,

We recently exported a spreadsheet with a list of requirement links from eaXL but the completed export contains an odd issue that only occurs for requirements that have several links. As each unique link is separated by a line break, there seems to be a phantom space (you are able to select this space but it appears almost invisible with a width of 0) right before each line break. This issue is currently preventing us from using the text to column feature in Excel as the function is only picking up the first unique link and not the subsequent ones.

An example is provided in the string below:

“Link 1,[space][phantom space]
Link 2,[space][phantom space]
Link 3″

If anyone has a suggested fix for this please let us know. Thanks!

10 January 2018 at 5:14 pm #9150

eadocX Support
Participant

Hi Dina,
(i think this problem has my name on it…)
It looks like eaDocX inserts a comma, then a space, then a CRLF character between the elements: makes it look sensible when put into a Word doc.
CRLF = ASCII chr(13) & chr(10), so a find/replace on this character sequence should fix it.

10 January 2018 at 5:43 pm #9151

Dina O’Donnell
Participant

Just tried out this solution and it worked perfectly. Thank you very much!
Author

Posts

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

Compare licence prices

Choose the licence that’s right for you and your team

Prices

Download a free trial

Download eaTeamWorks today for several free for life features, plus no obligation, 30-day trials of all the products: eaDocX, ea Revision Manager, eaSheets, Model Expert and PortfolioManager. Discover for yourself why we sell the world’s best-selling Enterprise Architect extension.

Download