To Read a File and Insert a part of the lines into the database Post: 302371629

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to insert data in database based on text file?

Hi....can you guys help me out in this script?? Below is a text file script....called Bukom.txt and it contains these: BUKOM 20060101 2.5 2.6 2.7 2.8 2.9 2.3 2.1 BUKOM 20060102 2.4 2.5 2.6 2.7 2.7 2.6 2.4 BUKOM 20060103 2.1 ...

2. Shell Programming and Scripting

How to insert data into MYSql database from a text file

Hi, Need to get help from you guys about this issue. I need to insert data into MySql database from a text file which is located in other server. The text file is something look like below: Date | SubscriberNo | Call Duration 20/7/07 | 123456788 | 20 20/7/07 | 123412344 | 30 The...

3. Shell Programming and Scripting

how to insert data into database by reading it from a text file??

Hi....can you guys help me out in this script?? Below is a text file and it contains these: GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001 GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001 GEF001 000093625 MKL005675 000001...

4. Web Development

INSERT data to a Database Table from a text file

If you have a text file and if you want to Insert data to your Database Table, You can do it with these queries LOAD DATA LOCAL INFILE '/path/yourTextFile.txt' INTO TABLE yourTableName FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n'

5. Shell Programming and Scripting

read database tablename from another file

i hava a file which contains database like emp dept loc now i want to create a script that read this file line by line and create a seperate query that ll be run in database like.. DELETE FROM TRS_ONE_ATDE WHERE DATA_DT = <from file> how can this be achieved. pls help.

6. Shell Programming and Scripting

Korn shell program to parse CSV text file and insert values into Oracle database

Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database. I need to write the korn shell program on Red Hat Enterprise Linux server. Oracle database is 10g.

7. Shell Programming and Scripting

How to read a text file line by line and insert into a database table?

I have a test file that I want to read and insert only certain lines into the the table based on a filter. 1. Rread the log file 12 Hours back Getdate() -12 Hours 2. Extract the following information on for lines that say "DUMP is complete" A. Date B. Database Name C....

8. Shell Programming and Scripting

Parse log file to insert into database

I have a log file that's created daily by this command: sar -u 300 288 >> /var/log/usage/$(date "+%Y-%m-%d")_$(hostname)_cpu.log It that contains data like this: Linux 3.16.0-4-amd64 (myhostname) 08/15/2015 _x86_64_ (1 CPU) 11:34:17 PM CPU %user %nice ...

9. Shell Programming and Scripting

Read latest log files and perform database insert

Hi Experts, I have a situation where I need to write a shell script to continuously monitor a log directory with multiple log files and perform following: 1. Read the latest log file continuously and grep "Success" OR "Failure" 2. As it capture either Success or Failure, it has to perform a...

10. UNIX for Beginners Questions & Answers

How to make a loop to read the input from a file part by part?

Hi All, We've a VDI infrastructure in AWS (AWS workspaces) and we're planning to automate the process of provisioning workspaces. Instead of going to GUI console, and launching workspaces by selecting individual users is little time consuming. Thus, I want to create them in bunches from AWS CLI...

LEARN ABOUT DEBIAN

netsds::util::datetime

NetSDS::Util::DateTime(3pm)				User Contributed Perl Documentation			       NetSDS::Util::DateTime(3pm)

NAME

       NetSDS::Util::DateTime - common date/time processing routines

SYNOPSIS

	       use NetSDS::Util::DateTime;

	       print "Current date: " . date_now();

DESCRIPTION

       This package provides set of routines for date and time processing.

EXPORTED FUNCTIONS

       date_now_array([TIME])
	   Returns array of date items for given date.	If source date is not set current date used.

       date_now([TIME])
	   Return [given] date as string.

	       2001-12-23 14:39:53

       date_now_iso8601([TIME])
	   Return date as ISO 8601 string.

	       20011223T14:39:53Z

	   <http://en.wikipedia.org/wiki/ISO_8601> http://www.w3.org/TR/NOTE-datetime <http://www.w3.org/TR/NOTE-datetime>

       date_strip(DATE)
	   Trim miliseconds from date.

       date_date(DATE)
	   Trim time part from date.

       date_time(DATE)
	   Trim date part from date.

       time_from_string($string)
	   Return parsed date/time structure.

       date_from_string($string)
	   Return date from string representation.

       date_inc([INCREMENT, [TIME]])
	   Return date incremented with given number of seconds.

       date_inc_string([INCREMENT, [TIME]])
	   Return string representation of date incremented with given number of seconds.

EXAMPLES

       None yet

BUGS

       Unknown yet

SEE ALSO

       Date::Parse, Date::Format

TODO

       Import stuff from Wono project

AUTHOR

       Valentyn Solomko <val@pere.org.ua>

       Michael Bochkaryov <misha@rattler.kiev.ua>

perl v5.12.4							    2011-08-27					       NetSDS::Util::DateTime(3pm)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to insert data in database based on text file?

Discussion started by: forevercalz

2. Shell Programming and Scripting

How to insert data into MYSql database from a text file

Discussion started by: shirleyeow

3. Shell Programming and Scripting

how to insert data into database by reading it from a text file??

Discussion started by: pallavishetty

4. Web Development

INSERT data to a Database Table from a text file

Discussion started by: sitex