[
http://jira.codehaus.org/browse/MSQL-40?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Robert Scholte closed MSQL-40.
------------------------------
Resolution: Fixed
Fix Version/s: 1.4
Assignee: Robert Scholte
Both solutions has been added in [rev. 11676 |
http://fisheye.codehaus.org/changelog/mojo/trunk/mojo/sql-maven-plugin?cs=11676]
You can set the outputDelimiter inside the configuration of the plugin.
If it's a comma, the value will be escaped according to the csv-rules if
required
> 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.
> Assignee: Robert Scholte
> Fix For: 1.4
>
>
> 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
