shell script to read data from text file and to load it into a table in TOAD Post: 302253100

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script to Load data into the database using a .csv file and .ctl file

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:

2. Shell Programming and Scripting

load a data from text file into a oracle table

Hi all, I have a data like, 0,R001,2,D this wants to be loaded into a oracle database table. Pl let me know how this has to be done. Thanks in advance

3. Shell Programming and Scripting

Load data to flat file from table.

Hi all, I need to know how to copy data from a table say ABC to a flat file say XYZ.dat in unix, Please leave ur comments and the fastest way to do so, I need to load the table records into flat file. Regards Ann

4. Shell Programming and Scripting

Shell script to read lines in a text file and filter user data

hi all, I have this file with some user data. example: $cat myfile.txt FName|LName|Gender|Company|Branch|Bday|Salary|Age aaaa|bbbb|male|cccc|dddd|19900814|15000|20| eeee|asdg|male|gggg|ksgu|19911216||| aara|bdbm|male|kkkk|acke|19931018||23| asad|kfjg|male|kkkc|gkgg|19921213|14000|24|...

5. Shell Programming and Scripting

How to read the data from the text file in shell script?

I am having one text file and i need to read that data from my shell script. I will expain you the scenario: Script look like: For name type 1: For age type 2: For Salary type3: echo "Enter the input:" read the data if input is 1 then go to the Text file and print the...

6. Shell Programming and Scripting

Shell script to find specific file name and load data

I need help as to how to write a script in Unix for the following: We have 3 servers; The mainframe will FTP them to a folder. In that folder we will need the script to look and see if the specific file name is there and load it to the correct table. Can anyone pls help me out with...

7. Shell Programming and Scripting

Bash shell script that inserts a text data file into an HTML table

hi , i need to create a bash shell script that insert a text data file into an html made table, this table output has to mailed.I am new to shell scripting and have a very minimum idea of shell scripting. please help.

8. Shell Programming and Scripting

How to read file and load data into a script as variable

I need to read a text file that contain columns of data, i need to read 1st column as a function to call, and others are the data i need to get into a ksh script. I am quite new to ksh scripting, i am not very sure how to read each row line by line and the data in each columns of that line, set...

9. Homework & Coursework Questions

Write a shell script for SQL loader to load data into a staging table

Hi, I'm new to Linux. I'm working on a database, and need to load data in a database table (which I already created) using shell script. The table has two columns - Acct_number (not nullable) and date (timestamp). I'm not able to write a shell script for that. Can any one help me? ...

10. UNIX for Dummies Questions & Answers

Shell script to read lines in a text file and filter user data Shell Programming and Scripting

sxsaaas

LEARN ABOUT DEBIAN

input

INPUT(5)							File Formats Manual							  INPUT(5)

NAME

       input - input data file format

DESCRIPTION

       This  manual  page  describes  the  output format of the file created by the Yagi-Uda project input or first programs. The file is an ASCII
       file, so can be edited manually if required. It is read by yagi or optimise.  The program optimise also creates the same file format.

       NOTES
       FREQUENCY
       MIN_FREQUENCY
       MAX_FREQUENCY
       STEP_FREQUENCY
       ELEMENTS
       DRIVEN
       PARASITIC
       ANGULAR_STEP
       DATA_DRIVEN
       DATA_PARASITIC

       The
       #
       is used as a comment.

       A typical file, for an antenna designed for the 2m amateur band (144-146
       MHz) might be as shown below. Note:
       1) Reflector is at position 0.0
       2) All elements lengths/positions are in m.

       NOTES This line can be up to 400 characters.
       FREQUENCY 145.000000
       MIN_FREQUENCY 144.000000
       MAX_FREQUENCY 146.000000
       STEP_FREQUENCY 0.100000
       ELEMENTS 10
       DRIVEN 1
       PARASITIC 9
       ANGULAR_STEP   180.000000
       #DATA_DRIVEN x y length	diameter voltage phase
       DATA_DRIVEN  0.30993 0.000000 1.002492 0.0063000000000000 1.000000 0.000000
       # DATA_PARASITIC x y length  diameter
       DATA_PARASITIC
	  0.00000    0.00000	1.01902    0.00630
	  0.49859    0.00000	0.95551    0.00630
	  1.07338    0.00000	0.93595    0.00630
	  1.81020    0.00000	0.92050    0.00630
	  2.58152    0.00000	0.91322    0.00630
	  3.30390    0.00000	0.91243    0.00630
	  4.03692    0.00000	0.90423    0.00630
	  4.64108    0.00000	0.89081    0.00630
	  5.37418    0.00000	0.83912    0.00630

FILES

	    filename				ASCII description of antenna.	    filename.out			binary file

SEE ALSO

       yagi(1), output(1), input(1), optimise(1), first(1) and yagi(5).

AUTHORS

       Dr. David Kirkby G8WRB (david.kirkby@onetel.net), with help with converting to DOS from Dr. Joe Mack NA3T (mack@fcrfv2.ncifcrf.gov).

Yagi version 1.16						 24th October 2000							  INPUT(5)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script to Load data into the database using a .csv file and .ctl file

Discussion started by: Csmani

2. Shell Programming and Scripting

load a data from text file into a oracle table

Discussion started by: raji35

3. Shell Programming and Scripting

Load data to flat file from table.

Discussion started by: Haque123

4. Shell Programming and Scripting

Shell script to read lines in a text file and filter user data

Discussion started by: srimal