Output format can have other available delimiters. Not just csv file type.
---------------------------------------------------------------------------
Key: MSQL-40
URL: http://jira.codehaus.org/browse/MSQL-40
Project: Maven 2.x SQL Plugin
Issue Type: Wish
Affects Versions: 1.3
Environment: RHEL 5 server, Windows XP SP3 workstation. Maven 2
(2.0.9)
Reporter: Mike D.
Currently the sql plugin only creates an output file with comma's as the field
delimiter. An issue arises when commas are present within the values of the
data being extracted and then manipulated elsewhere. (I.e. Excel, MS Access,
Oracle, etc...).
Two approaches to resolve this issue are:
1) create the CSV output as comma delimited but quotes around the values. Or
2) allow for another character (I.e. tab) to be the delimiter. This could be
a custom value or preset as a tab for example.
I unfortunately do not have a junit test case to provide. However, can provide
the Oracle user query if that would be of assistance. The query obtains the
"comments" column from a system view. The comments include commas. Therefore
when this data is imported in our documentation system, multiple columns are
created when this should be maintained as a single column.
Thanks,
Mike
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
