#11961: DB-Excel:"-DQ" command is not working for double quotes in fluid shell.

saima.alvi(*) reported 2014-04-28T12:48:27Z · last modified 2018-03-08T21:32:05Z

Dev	SachinPrakash
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - Excel
Version	Future - PM

Aqua Data Studio 15.0.0-dev-252

Build #: 37537

Built on: 2014-Apr-25 04:30:08 PM

Operational environment:Windows 7(6.1,amd64)/Cp1252/1.7.0_2

Issue:DB-Excel:"-DQ" command is not working for double quotes in fluid shell.

Steps to reproduce:

1.Download and save attached .xls file and open it with ms Excel drivers.

2.Expand the database in which you saved the file,right click on the schema "date" and open fluid shell.

3.In fluid shell run the the given command.

sqlexport -s date -f 'csv' -DQ 'double-quote' -o E:/datequotes.csv table

->open the datesquotes file,you will find that double quotes are not applied.

All Comments (4) Change History

tariqrahiman 2014-04-28T18:04:26Z

@saima: can you verify if this works correctly for other databases like SQL Server or MySQL etc ?

saima.alvi(*) 2014-04-29T06:10:35Z

@ tariq

In SQL server 2012 also -DQ and -SQ command is not working for double quotes,given below is the command which I used.

sqlexport -s db_accessadmin -f 'csv' -DQ 'double-quote' -SQ 'double-quote' -o E:/stringquote-double-quote_sqlserver1 all_datatypes1

I am attaching resulting csv file.

Thanx

saima.alvi(*) 2014-04-30T12:18:40Z

This issue can also be reproduced with Export tool.

tariqrahiman 2014-04-30T18:00:38Z

@saima : Let me go through Export Tool and then update this issue accordingly.