Sponsored Content
Top Forums Programming How to extract data from CVS log files and store it in database ? Post 302606940 by EVERSOFT on Tuesday 13th of March 2012 07:42:08 AM
Old 03-13-2012
How to extract data from CVS log files and store it in database ?

Am currently working on CVS projects .. I have generated the cvs log file which is in the RCS file format . .I want to extract file path ,total revision ,date ,author and message from that file . .I want a program in java which would extract the data from cvs log file. .Pls help me out..

My sample input file :

Code:
RCS file: RCS/our_file.txt,v
Working file: our_file.txt
head: 1.3
branch:
locks: strict
access list:
symbolic names:
keyword substitution: kv
total revisions: 3;     selected revisions: 3
description:
Our Example RCS Text File
----------------------------
revision 1.3
date: 2003-05-27 03:11:54-04;  author: ashawley;  state: Exp;  lines: +1 -0
Added Id keyword.
----------------------------
revision 1.2
date: 2003-05-27 03:08:56-04;  author: ashawley;  state: Exp;  lines: +1 -0
Added another question.
----------------------------
revision 1.1
date: 2003-05-27 03:07:51-04;  author: ashawley;  state: Exp;
Initial revision
=============================================================================
RCS file: RCS/our_file.txt,v
Working file: our_file.txt
head: 1.3
branch:
locks: strict
access list:
symbolic names:
keyword substitution: kv
total revisions: 3;     selected revisions: 3
description:
Our Example RCS Text File
----------------------------
revision 1.3
date: 2003-05-27 03:11:54-04;  author: ashawley;  state: Exp;  lines: +1 -0
Added Id keyword.
----------------------------
revision 1.2
date: 2003-05-27 03:08:56-04;  author: ashawley;  state: Exp;  lines: +1 -0
Added another question.
----------------------------
revision 1.1
date: 2003-05-27 03:07:51-04;  author: ashawley;  state: Exp;
Initial revision
=============================================================================

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extracting data and store in database

Hello all, I have this text file data. The data are separated by comma in three column and space or line feed to start a new row anderson helberg, Jane, brother Sister ,mother,grandpa bombay,new york, china I would like store them in the following format. field1 ... (2 Replies)
Discussion started by: mam
2 Replies

2. Shell Programming and Scripting

Need shell script to extract data from oracle database

shell script (4 Replies)
Discussion started by: frns5
4 Replies

3. 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... (1 Reply)
Discussion started by: psiva_arul
1 Replies

4. UNIX and Linux Applications

Retrieving data from a database and store to a file

Hi I'm using and Oracle 10g Database. I want to write a script to retrieve data from the database and store it toa file. I'm using simple sql statements such as Select * from celltable I don't know how to specify the database name etc. I have this but it doesn't work ... (1 Reply)
Discussion started by: ladyAnne
1 Replies

5. Shell Programming and Scripting

How to extract data from indexed files (ISAM files) maintained in an unix server.

Hi, Could someone please assist on a quick way of How to extract data from indexed files (ISAM files) maintained in an UNIX(AIX) server.The file data needs to be extracted in flat text file or CSV or excel format . Usually we have programs in microfocus COBOL to extract data, but would like... (2 Replies)
Discussion started by: devina
2 Replies

6. Shell Programming and Scripting

How to extract data into excel from a database in unix

Hello viewers, I am connecting to db2 database from unix. I am executing a query for example select * from emp. I need to export the data obtained from the above command to a excel file. Could you please suggest how to proceed on this? thanks and regards, k.n.v.santosh (3 Replies)
Discussion started by: santoshaarudhra
3 Replies

7. Shell Programming and Scripting

Extract text and store in separate files

Hi, I have a file which looks like this: .I 1 some text .A this is the first line .I 2 some text again .B this is the second line .I 3 again some text .C this is the third line I want to have my output like this in separate files: (7 Replies)
Discussion started by: shoaibjameel123
7 Replies

8. Shell Programming and Scripting

Execute sequential files and store data in single file

1)In a particualr path i have a set of inputfiles like path:/defaultmis/MonthlyLoads/INFA_EXPORT_022013/map* example: 1)map_de 2)map_cod 3)map_feg ........and so on in above path there wil be nearly 15 to 20 files starting with map and in other path i have another file input file... (4 Replies)
Discussion started by: katakamvivek
4 Replies

9. UNIX for Dummies Questions & Answers

Extract data from a file and store it in a variable

Hi , I have an file like below , cat input.txt 'Pattern2' => 'blahdalskdahdlahldahdlakhdlahdlkajdlkaadasdadadadadadadasda ajlalnalndklandlaksdlkaddd' 'Pattern2' => 'aohaonalkndlanldandlandklasnldnaldnak' ............ ........ ..... Here is what am trying to do , I want to grep for... (3 Replies)
Discussion started by: scott_cog
3 Replies

10. UNIX for Dummies Questions & Answers

Read in Multiple log files and output selected variables and values to cvs file

I have several problems with my problems: I hope you can help me. 1) the If else statement I am getting an error message. My syntax must be incorrect because the entire statement is throwing an error. For example in filew.log if these items don't exist Memsize, SASFoundation and also if... (0 Replies)
Discussion started by: dellanicholson
0 Replies
IDENT(1)						      General Commands Manual							  IDENT(1)

NAME
ident - identify RCS keyword strings in files SYNOPSIS
ident [ -q ] [ -V ] [ file ... ] DESCRIPTION
ident searches for all instances of the pattern $keyword: text $ in the named files or, if no files are named, the standard input. These patterns are normally inserted automatically by the RCS command co(1), but can also be inserted manually. The option -q suppresses the warning given if there are no patterns in a file. The option -V prints RCS's version number. ident works on text files as well as object files and dumps. For example, if the C program in f.c contains #include <stdio.h> static char const rcsid[] = "$Id: f.c,v 5.4 1993/11/09 17:40:15 eggert Exp $"; int main() { return printf("%s ", rcsid) == EOF; } and f.c is compiled into f.o, then the command ident f.c f.o will output f.c: $Id: f.c,v 5.4 1993/11/09 17:40:15 eggert Exp $ f.o: $Id: f.c,v 5.4 1993/11/09 17:40:15 eggert Exp $ If a C program defines a string like rcsid above but does not use it, lint(1) may complain, and some C compilers will optimize away the string. The most reliable solution is to have the program use the rcsid string, as shown in the example above. ident finds all instances of the $keyword: text $ pattern, even if keyword is not actually an RCS-supported keyword. This gives you infor- mation about nonstandard keywords like $XConsortium$. KEYWORDS
Here is the list of keywords currently maintained by co(1). All times are given in Coordinated Universal Time (UTC, sometimes called GMT) by default, but if the files were checked out with co's -zzone option, times are given with a numeric time zone indication appended. $Author$ The login name of the user who checked in the revision. $Date$ The date and time the revision was checked in. $Header$ A standard header containing the full RCS file name, the revision number, the date and time, the author, the state, and the locker (if locked). $Id$ Same as $Header$, except that the RCS file name is without directory components. $Locker$ The login name of the user who locked the revision (empty if not locked). $Log$ The log message supplied during checkin. For ident's purposes, this is equivalent to $RCSfile$. $Name$ The symbolic name used to check out the revision, if any. $RCSfile$ The RCS file name without directory components. $Revision$ The revision number assigned to the revision. $Source$ The full RCS file name. $State$ The state assigned to the revision with the -s option of rcs(1) or ci(1). co(1) represents the following characters in keyword values by escape sequences to keep keyword strings well-formed. char escape sequence tab newline space 40 $ 44 \ IDENTIFICATION
Author: Walter F. Tichy. Manual Page Revision: 5.8.1; Release Date: 2012-06-06. Copyright (C) 2010-2012 Thien-Thi Nguyen. Copyright (C) 1990, 1992, 1993 Paul Eggert. Copyright (C) 1982, 1988, 1989 Walter F. Tichy. SEE ALSO
ci(1), co(1), rcs(1), rcsdiff(1), rcsmerge(1), rlog(1), rcsfile(5). Walter F. Tichy, RCS--A System for Version Control, Software--Practice & Experience 15, 7 (July 1985), 637-654. GNU RCS 5.8.1 2012-06-06 IDENT(1)
All times are GMT -4. The time now is 06:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy