473,320 Members | 1,945 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

CSV file enclosed by "

1
Hi all!

I need some help with a csv file im exporting. The file is coming like this:

000050222,1,AB2500AW,2007,10,32,2,+1.00

and i need to enclose some colums with double quotes so the file could look like this:


000050222,"1","AB2500AW","2007","10","32","2","+1. 00"

im using oracle 10g, on Unix OS, and im new to Oracle


Any help will be useful.
Thanks!
Nov 6 '08 #1
3 2695
Pilgrim333
127 100+
Hi,

You can escape it by using "" eg.

Select ""test"" from dual;

Will result in "test"

Pilgrim.
Nov 6 '08 #2
amitpatel66
2,367 Expert 2GB
Please post your query that you are using to export the data from oracle table in to a csv file?
Nov 7 '08 #3
Pilgrim333
127 100+
My Booboo,

That ofcourse should be
Expand|Select|Wrap|Line Numbers
  1.  select ' "test" ' from dual 
Using it in a pl/sql procedure in which you are generating an output string it would be

Expand|Select|Wrap|Line Numbers
  1.  l_text := ' " ' <variable> || ' "; '  <etc> ; 
(get rid of the spaces between the single and double quotes)

Pilgrim
Nov 7 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Luis Esteban Valencia | last post by:
Hello I have this code and It runs FINE but vs.net 2003 doesnt let me switch to design mode <asp:DataList id="datalistpartidos" runat="server" GridLines="Vertical" CellPadding="3"...
4
by: spwpreston | last post by:
Hello, I am new to MySQL. I am trying to load from a text file to a table, and am having problems with the fields in the text file being translated to the correct fields in the TABLE. Right...
8
by: MLH | last post by:
Am trying to import 20,000+ lines of text in a file FTP'd from a UNIX platform to windows via FTP session in a DOS box. About 2000 records have multiple lines in them separated by CRLF's. ...
13
by: DH | last post by:
Hi, I'm trying to strip the html and other useless junk from a html page.. Id like to create something like an automated text editor, where it takes the keywords from a txt file and removes them...
7
by: pkirk25 | last post by:
My data is in a big file that I have no control over. Sometimes its over 30 MB and often there are several of them. It is machine generated and is nicely formatted. Example text follows: ...
1
by: vmoreau | last post by:
I have a text and I need to find a Word that are not enclosed in paranthesis. Can it be done with a regex? Is someone could help me? I am not familar with regex... Example looking for WORD:...
1
by: Abhishek Bhatt | last post by:
Need to export table into csv file. Tried following: DoCmd.TransferText acExportDelim, "", TABLENAME, "C:\abc.csv", False, "" But the exported file contains data enclosed in double quotes i.e....
0
by: lanesbalik | last post by:
hi all, right now i'm trying to migrate from db2 running under linux to mysql v5.1. i manage to export out the db2 structure & data into a del (ascii) file. but when i try to load the data...
3
by: sejal17 | last post by:
hello Can any one tell me how to read multiple worksheets from a single excel file.I have stored that excel in xml file.so i want to read that xml that has multiple worksheet.And i want to store...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.