Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: qwerty on April 06, 2017, 08:44:34 pm

Title: Copy search result should use tabs iso. semi-colon
Post by: qwerty on April 06, 2017, 08:44:34 pm

When you Ctrl-C the result of a SQL query, EA separates the result string with semi-colon. But of course 1/4 of all fields itself contain semi-colon separated lists. So using the result is best a good guess work. So rather to use the dreaded semi-colon EA should use a tab char. Or make it an optional choice.

q.

Title: Re: Copy search result should use tabs iso. semi-colon
Post by: Eve on April 07, 2017, 08:24:15 am

I think it uses the locale for separators specified in Windows. (Which would be why us comma users have never seen it as a problem)

Title: Re: Copy search result should use tabs iso. semi-colon
Post by: Geert Bellekens on April 07, 2017, 04:05:55 pm

More problematic is are the newlines in the "CSV" export (which isn't fully CSV compatible)
I just recently  wrote an excel wrapper script to import/export to excel directly  in order to avoid these types of issues.
See https://github.com/GeertBellekens/Enterprise-Architect-VBScript-Library/blob/master/Framework/Utils/ExcelFile.vbs

Geert

Title: Re: Copy search result should use tabs iso. semi-colon
Post by: qwerty on April 07, 2017, 07:06:30 pm

Sigh. Us and them. More popular than ever...

q.

Title: Re: Copy search result should use tabs iso. semi-colon
Post by: Helmut Ortmann on April 10, 2017, 06:40:00 pm

Hi,

To avoid the trouble with *.csv, and to make it more convenient hoTools (https://github.com/Helmut-Ortmann/EnterpriseArchitect_hoTools/wiki) supports:
- *.csv to Excel
- SQL search results to Excel

I may in future, like Geert, integrate a wrapper for all kind of EA Searches

Kind regards,

Helmut