As Peasant commented, Windows associates CSV extension to Excel (by default), so Excel will open it.
To extract the data we have some options:
Just one more comment, be sure that there are no "," in the fields you are extracting, otherwise you may face problems or, in every field you extract, you can use the Oracle REPLACE function:
I hope it helps!
Hi,
Can anyone tell the option to change the file type in unix.
i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format.
Thanks in advance,
Milton. (1 Reply)
Hi,
I need to ftp a .xls file from WINDOWS to UNIX. When I do it, the file coversion doesn't happen(??) or UNIX doesn't recognixe this format I know not. But there will be junk values in the ftp'd file.
Note: The ftp will be done by a script and I don't think we could place a WINDOWS script on... (5 Replies)
Ok, every morning at my office we send out excel sheets to Economy people with statistics for yesterdays trading.
All the trading run's in Redhat or Solaris environments.
We run a script on a Redhat server whitch generates the stats in CSV format.
After we download we open it in Excel and... (3 Replies)
A unix script generates a file "1.csv". I use the following to email this as an excel sheet.
/usr/bin/uuencode /tmp/1.csv 1.csv > $PATH/attachment.txt
mailx -r abc@domain.com -s "Subject" myself@domain.com < $PATH/attachment.txtI get the file as CSV in the email and everything is fine except... (9 Replies)
Hello
I have a script which converts log to csv.
Now I need to have xls.
Is there any easy way/command which can convert csv to xls?:confused:
preferably just using bash and not perl,... is it possible? (1 Reply)
Discussion started by: frhling
1 Replies
LEARN ABOUT CENTOS
reset
RESET(7) PostgreSQL 9.2.7 Documentation RESET(7)NAME
RESET - restore the value of a run-time parameter to the default value
SYNOPSIS
RESET configuration_parameter
RESET ALL
DESCRIPTION
RESET restores run-time parameters to their default values. RESET is an alternative spelling for
SET configuration_parameter TO DEFAULT
Refer to SET(7) for details.
The default value is defined as the value that the parameter would have had, if no SET had ever been issued for it in the current session.
The actual source of this value might be a compiled-in default, the configuration file, command-line options, or per-database or per-user
default settings. This is subtly different from defining it as "the value that the parameter had at session start", because if the value
came from the configuration file, it will be reset to whatever is specified by the configuration file now. See Chapter 18, Server
Configuration, in the documentation for details.
The transactional behavior of RESET is the same as SET: its effects will be undone by transaction rollback.
PARAMETERS
configuration_parameter
Name of a settable run-time parameter. Available parameters are documented in Chapter 18, Server Configuration, in the documentation
and on the SET(7) reference page.
ALL
Resets all settable run-time parameters to default values.
EXAMPLES
Set the timezone configuration variable to its default value:
RESET timezone;
COMPATIBILITY
RESET is a PostgreSQL extension.
SEE ALSO SET(7), SHOW(7)PostgreSQL 9.2.7 2014-02-17 RESET(7)