Store table contents in csv file Post: 302441716

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 DEBIAN

dbatbl

DBATBL(1)						      General Commands Manual							 DBATBL(1)

NAME

       dbatbl - Manage on-disk reference tables for DB-ALLe

SYNOPSIS

       dbatbl [command] [options] [args...]

DESCRIPTION

       This tool allows to index and query the tables that are needed for normal functioning of DB-ALLe.

       dbatbl always requires a non-switch argument, that indicates what is the operation that should be performed:

       help
	      Print a help summary.

       help manpage
	      Print this manpage.

       cat tableid [tableid [...]]
	      Output all the contents of a WMO B table..

       grep string
	      Output all the contents of the local B table whose description contains the given string..

       expand table-entry [table-entry [...]]
	      Describe a WMO B table entry or expand a WMO D table entry in its components..

       expandcode varcode [varcode [...]]
	      Expand the value of a packed variable code.

       index [options] filename index-id
	      Index the contents of a table file.

       describe [options] what [values]
	      Invoke the formatter to describe the given values.  Supported so far are: "level ltype l1 l2", "trange pind p1 p2".

OPTIONS

       dbatbl follows the usual GNU command line syntax, with long options starting with two dashes (`-').

   Option for command cat
       -?, --help
	      print an help message

       -c, --csv
	      output variables in CSV format

   Option for command grep
       -?, --help
	      print an help message

       -c, --csv
	      output variables in CSV format

   Option for command expand
       -?, --help
	      print an help message

   Option for command expandcode
       -?, --help
	      print an help message

   Option for command index
       -?, --help
	      print an help message

       -t type, --type=type
	      format of the table to index ('b', 'd', 'conv')

   Option for command describe
       -?, --help
	      print an help message

AUTHOR

       dbatbl has been written by Enrico Zini <enrico@enricozini.com> for ARPA Emilia Romagna, Servizio Idrometeorologico.

								   may 16, 2012 							 DBATBL(1)