|
jred33
Posts: 8
|
 |
|
Is it possible to remove double quotes from data in SQL?
Posted: 09 Nov 11 9:55 AM
|
Is it possible to remove double quotes from data in SQL prior to creating the .csv files?
Double quotes entered in item names for inventory are causing the .csv files to be malformed.
We attempted SQL replace function, but it is not working properly.
Please advise.
Thanks,
Jeremy |
|
|
John Lathem
Posts: 78
|
 |
|
Re: Is it possible to remove double quotes from data in SQL?
Posted: 16 Nov 11 11:15 AM
|
If I understand you correctly, you are saying that you are having trouble using Validation Files generated from SQL Server when there is data in the file that contains double-quotes? If that's the case, it sounds like there may be an issue with the escaping of double-quotes in our generated CSV files. We will look into this.
However, if this data is only used for a Validation File for lookups on the device, you might want to consider using Tab-Delimited with no text qualifier instead of Comma-Delimited. This works well because the file data never contains the delimiter (Tab). |
|
|
jred33
Posts: 8
|
|
|
Re: Is it possible to remove double quotes from data in SQL?
Posted: 16 Nov 11 11:26 AM
|
Yes, that is correct. We have item names in our inventory that have double quotes to represent inches.
example: Band Aids 3" x 4"
The generated CSV files are not handling this well as you can imagine.
In the short term we have disallowed double quotes to be used for these fields in our web based application that synchs with the Oracle XE database that Omni Server is accessing.
I will look into the Tab-Delimited option. |
|
|
|