01-24-2019
I think in sqlplus there is a colsep setting.
set colsep |
to set to a | pipe character
you can then do a manual export into Excel, specifying the | as delimiter or
edit(replace) the , to ; and then the | to , --> and you would have a csv file with ; between elements
Otherwise, perhaps format your output inside you SELECT statement.
This User Gave Thanks to joeyg For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are
1. The Control file name(.ctl file)
2. The Data file name(.csv file)
Does anybody have an idea about it? :confused: (3 Replies)
Discussion started by: Csmani
3 Replies
2. Shell Programming and Scripting
TEST_HEME,"SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1",CELL
when I split by
FS=","
then
$0=TEST_HEME
$1="SubNetwork=ONRM_RootMoR
$2=SubNetwork=ARNC1"
but I need this will be single value
"SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1" (4 Replies)
Discussion started by: Hemendra
4 Replies
3. Shell Programming and Scripting
Friends...This is the first time i am trying the report generation using shell script... any suggestions are welcome.
Is there a way to set the font size & color when i am exporting the data from unix shell script as a CSV file ?
The following sample data is saved as a .csv file in the... (2 Replies)
Discussion started by: appu2176
2 Replies
4. Shell Programming and Scripting
I need to read data from a file called "test.csv" through shell script where the file contains values like name,price,descriptor etc. There are rows where descriptor (& in some rows name) are written as string & other characters like "car_+" OR "bike*" etc where it should contains strings like... (3 Replies)
Discussion started by: raj100
3 Replies
5. Shell Programming and Scripting
Name,,,,,,,,,,,,,,,,,,,,Domain,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Contact,Phone,Email,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Location
-----------------------,------------------------------------------------,-------,-----,---------------------------------,------------------------------------
----... (1 Reply)
Discussion started by: sreenath1037
1 Replies
6. UNIX for Dummies Questions & Answers
Hi Guys,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm.... (1 Reply)
Discussion started by: Vivekit82
1 Replies
7. UNIX for Dummies Questions & Answers
Hi Guys,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 7 columns having values say column 1,column 2.....column 7 as below along with their values.
Name, Address,... (7 Replies)
Discussion started by: Vivekit82
7 Replies
8. Shell Programming and Scripting
Hi everyone,
I have a csv file which has data with different heading and column names as below.
Static Data Ingested
,,,,,,,,,,,,Known Explained Rejections
Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10 ,... (14 Replies)
Discussion started by: Vivekit82
14 Replies
9. Shell Programming and Scripting
Hi List,
I have a chunk of data like so:
User Account Control:
User Account Control:
User Account Control:
User Account Control:
Disabled
User Account Control:
User Account Control:
User Account Control:
Disabled
User Account Control:
User Account Control:
... (3 Replies)
Discussion started by: landossa
3 Replies
10. Shell Programming and Scripting
i have data as below
123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi"
i need an output to be
123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre Malawi" (5 Replies)
Discussion started by: mathias23
5 Replies
LEARN ABOUT SUNOS
evolution-addressbook-export
evolution-addressbook-export(1) User Commands evolution-addressbook-export(1)
NAME
evolution-addressbook-export - export local address book from Ximian Evolution, Sun Microsystems Edition
SYNOPSIS
evolution-addressbook-export [--async] [--format=[vcard|csv]] [--help] [--list-addressbook-folders] [--output=output-file] [--size=number]
[--usage] [--version]
DESCRIPTION
Export the local address book to a file.
OPTIONS
The following options are supported:
--async Export in asynchronous mode. You can also use -a to specify this option.
--format=[vcard|csv] Specify the export format: virtual card (vcard) or comma-separated value (csv).
--help Display help text. You can also use -? to specify this option.
--list-addressbook-foldeList the local address-book folders. You can also use -l to specify this option.
--output=output-file Specify the name of the output file to store the exported information. If no output file is specified, the exported
information is sent to standard output.
--size=number Specify the number of cards in one output file in asychronous mode. The default value is 100.
--usage Display brief usage text.
--version Display version information.
EXAMPLES
Example 1: Exporting Local Address Book in Asynchronous Mode and Vcard Format to contacts.vcf
example% evolution-addressbook-export -a --format=vcard --output=contacts.vcf
EXIT STATUS
The following exit values are returned:
0 Application exited successfully
1 Application exited with failure
FILES
The following files are used by this application:
/usr/bin/evolution-addressbook-export
Executable to export Evolution local address book
$HOME/evolution
Per-user configuration files and local storage for Evolution
$HOME/evolution/mail/account/folders
Temporary files for Evolution mail
$HOME/evolution/sunone/account/folders
Temporary files for Evolution Sun ONE account
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Architecture |SPARC |
+-----------------------------+-----------------------------+
|Availability |SUNWevo |
+-----------------------------+-----------------------------+
|CSI |Enabled |
+-----------------------------+-----------------------------+
|Interface stability |Standard |
+-----------------------------+-----------------------------+
|MT-Level |MT safe with Exceptions |
+-----------------------------+-----------------------------+
SEE ALSO
Ximian Evolution Sun Microsystems Edition User Guide
evolution(1), evolution-address-import(1)
NOTES
Written by Steven Zhang, Sun Microsystems Inc., 2004.
SunOS 5.10 15 Apr 2004 evolution-addressbook-export(1)