Store table contents in csv file Post: 302441734

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script for converting file contents into CSV

Hi, I am new in unix, I just want to replace some values from text file according to column numbers. Like, I am having a table as given below: val1 val2 val3 val4 val5 val6 val7 val8 val9 val10 val11 val12 val13 Now i want...

2. Shell Programming and Scripting

store the table data in excel file

Hello - I have a below table and i want to extract the data into excel sheet and send to different location. Here is the table structure... SQL> desc t_i1_exportdocs Name Null? Type ----------------------------------------- --------...

3. Shell Programming and Scripting

Most reliable way to store file contents in an array in bash

Hi Guys, I have a file which has numbers in it separated by newlines as follows: 1.113 1.456 0.556 0.021 -0.541 -0.444 I am using the following code to store these in an array in bash: FILE14=data.txt ARRAY14=(`awk '{print}' $FILE14`)

4. UNIX and Linux Applications

Does anybody know how to store my tables to a csv file?

Hi I'm using an oracle database... Lets call it databasename My username and password are the same .... lets all that andrea/andrea So I want to write a script to copy all the data from my table called tablename and store that data to a csv file called filename. I cant seem to get...

5. UNIX for Dummies Questions & Answers

Storing data from a table into a csv file

Hi I need to write a bash script to take the data stored in 3 oracle tables .. and filter them and store the results in a csv file. It is an Oracle database Thank you

6. Shell Programming and Scripting

Read the contents of a file and store them in a variable

Hi Gurus, I am trying for a scenario where in I want to read the contents of a file line by line and then store them in variables. Below is the script: #!/bin/ksh while read line do id=`echo $line | cut -f1 -d |` name=`echo $line | cut -f2 -d |` echo $id ...

7. Shell Programming and Scripting

Convert file in csv or table

Hi there, i have a file like that in attachment (PLEVA3_280711_SAP.txt), i would extract some basic information from it and report in a new file or table like this: i try to use bash and i extract the single object in this way (see attach scriptino.sh), but i receive a strange...

8. Shell Programming and Scripting

Place the contents of a .CSV file to an array

Hi, I am trying to place the contents of a .CSV file to an array, but not sure how to do that. Here is my .CSV file content: App,SLA,Job name,Avg start time,Avg run time,Frequency,Downstream apps XYZ,,ABC14345,3:00 AM,00.04.00,Daily,STAMP XYZ,9:00,ABC12345,3:15 AM,00.05.00,Daily,STAMP ...

9. Shell Programming and Scripting

Update the table using values from a csv file

i want to run update query for oracle which is in up.sql taking values from a.csv. I have implemented shell script to do it. extn="perl" ls -1 | while read file do echo "$file,$extn" > a.csv done up.sql contains update file_list set filename=$1 where extn=$2; The code to update is...

10. UNIX for Dummies Questions & Answers

Trying To Write File Contents To Specfic .csv Cell

Hi, I'm attempting to write the entire contents of a file to a specific .csv cell. So far have only a nawk one liner that will write a value into a specific .csv cell. Trying to use man page but can't seem to get any farther. Any help would be appreciated. nawk -v r=2 -v c=3 -v val=5 -F,...

LEARN ABOUT OSF1

script

script(1)						      General Commands Manual							 script(1)

NAME

       script - Makes a transcript of terminal session

SYNOPSIS

       script [-a] [file]

       The script command makes a transcript of everything printed on your terminal.

OPTIONS

       Appends the transcript to file rather than writing it to file.

OPERANDS

       The name of an output file that will contain the transcript of the session.  If this parameter is omitted, the file typescript is written.

DESCRIPTION

       The transcript is written to file, or appended to file if the -a option is given.  If no file name is given, the transcript is saved in the
       file typescript.

       The script ends when the forked shell exits.

       This program is useful when you are using a CRT and want a hard-copy record of the dialog (for example, a technical writer might create	an
       example of a working session this way).

       If you specify the -a option and the file does not exist, it is created.

       If you do not specify the -a option and the file exists, it is replaced.

RESTRICTIONS

       The  script command requires a streams based terminal.  In single user mode, streams may not be enabled.  Under these circumstances, script
       will exit with no action.  If you are the superuser and need to run this command in single user mode, use the  following  special  instruc-
       tions.

   Enabling Streams
       If it is necessary to enable a streams environment in the single user mode, enter the command /sbin/init.d/streams.  This command is avail-
       able to the superuser only.

SEE ALSO

       Commands:  autopush(8), cat(1), echo(1), strsetup(8), tee(1)

       System Administration

																	 script(1)