txt file to oracle database Post: 65497

Sponsored Content

Top Forums Shell Programming and Scripting txt file to oracle database Post 65497 by jorhul on Saturday 5th of March 2005 07:17:35 PM

03-05-2005

Registered User

txt file to oracle database

hiya,

i have a query: i want to read a file which contains:

2005/02/21 16:56:54.301: 111 PS (200, 10) sent <log instrument="FXA.ROSS" name="FXA.COSS.PAH.URR"><gid_id>1434025</gid_id><submit_id>22</submit_id><taker_name>shannop2</taker_name><taker_group_name>SupportClients/SupportUsers</taker_group_name><taker_account>Demo

2005/02/21 16:56:55.596: 111 PS (200, 10) sent <log instrument="FXA.ROSS" name="FXA.ROSS.PUR.URR"><gid_id>1534025</gid_id><submit_id>22</submit_id><taker_name>shannop2</taker_name><taker_group_name>SupportClients/SupportUsers</taker_group_name><taker_account>Demo

Now i want to grep just the timestamp (ie 16:56:54.301) & the gid_id (ie 1434025) in the first line & so on for all lines. Then insert this into a oracle database.

what i have done is i use the cut command to first cut the timestamp on each line & write to a file , then do the same with the gid_id. Finally paste the two files. It looks like this.

file1 : jo.txt

16:56:54.301
16:56:55.596

file2: jo1.txt

1434025
1534025

After paste, file3: jo3.txt

16:56:54.301 1434025
16:56:55.596 1534025

Question 1: is there an easeier way to do this?
Question 2: i want to read file3 (ie jo3.txt) & insert the contents into an oracle table

To do this, should i count the no. of lines in file3 (ie jo3.txt) using wc -l & then using a for loop connect to db using the sql -s user/passwd@server<<++>/dev/null & use the insert command?

would be great if i could get suggestions on this...plz

cheers,
Jo

jorhul

View Public Profile for jorhul

Find all posts by jorhul

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to extract the data from database (oracle) and send the output as an .xls file?

Hi, How to extract the data from Oracle database and sent the output data to mails using mailx command with .xls attachement? Here i know how to connect the database using unix shell script and how to use the mailx command in UNIX script But i don't know how to use the .xls format file (i...

2. Shell Programming and Scripting

Find similar entry in a .txt file acting as a database.

May i know how do i go along finding similar entry in a .txt file, which is used a as a "database" and post and error saying the entry existed when we key in the entry. ---------- Post updated at 05:18 PM ---------- Previous update was at 05:16 PM ---------- i mean post an error saying the...

3. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General...

4. Shell Programming and Scripting

Using csh / awk / sed to compare database sizes in a txt file

Hello, I have an output file showing database sizes across the 3 environments that I use (LIVE, TEST & DEVELOPMENT). I am trying to write a script that lets me know if the size of a db on one environment is different to its corresponding db on the other environments. Here is an example...

5. Shell Programming and Scripting

shellscript to read data from txt file and import to oracle db

Hi all, Help needed urgently. I am currently writing a shellscript to read data/record from a flat file (.txt) file, and import/upload the data to oracle database. The script is working fine, but it takes too long time (for 18000 records, it takes around 90 mins). I guess it takes so long...

6. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL...

LEARN ABOUT DEBIAN

atr_analysis

ATR_ANALYSIS(1p)						   User Commands						  ATR_ANALYSIS(1p)

NAME

       ATR_analysis - analyse a smart card ATR

SYNOPSIS

       ATR_analysis [ATRstring]

DESCRIPTION

       ATR_analysis is used to parse the ATR (Answer To Reset) sent by a smart card.

       The command also tries to find the card model using an ATR database stored in a text file smartcard_list.txt.

       The smartcard_list.txt file is searched in ./, /usr/local/pcsc/ and /usr/share/pcsc/ directories.

       Exemple:
	$ ATR_analysis '3B A7 00 40 18 80 65 A2 08 01 01 52'
	ATR: 3B A7 00 40 18 80 65 A2 08 01 01 52
	+ TS = 3B --> Direct Convention
	+ T0 = A7, Y(1): 1010, K: 7 (historical bytes)
	  TB(1) = 00 --> Programming Param P: 0, I: 0
	  TD(1) = 40 --> Y(i+1) = 0100, Protocol T = 0
	-----
	  TC(2) = 18 --> Work waiting time: 960 x 24 x (Fi/F)
	+ Historical bytes: 80 65 A2 08 01 01 52

	Possibly identified card:
	3B A7 00 40 18 80 65 A2 08 01 01 52
	       Gemplus GPK8000

BUGS

       Maybe many bugs since I am not a ISO 7816 expert.

FILES

       smartcard_list.txt

SEE ALSO

       pcscd(8), pcsc_scan(1)

AUTHOR

       Ludovic Rousseau <ludovic.rousseau@free.fr>

Version: 1.3							   October 2005 						  ATR_ANALYSIS(1p)