08-21-2005
Shell Script to read specific lines in a file
I have a file with contents as follows
Record 1: Rejected - Error on table "DWO"."P2G_CUST_EVENTS".
ORA-00001: unique constraint (DWO.CUST_EVENTS_PK) violated
Record 5: Rejected - Error on table "DWO"."P2G_CUST_EVENTS".
ORA-00001: unique constraint (DWO.CUST_EVENTS_PK) violated
Record 6: Rejected - Error on table "DWO"."P2G_CUST_EVENTS".
ORA-00256: integrity constraint (DWO.CUST_EVENTS_PK) violated
Record 7: Rejected - Error on table "DWO"."P2G_CUST_EVENTS".
ORA-00001: unique constraint (DWO.CUST_EVENTS_PK) violated
Now I need to find the record numbers against the rows having unique constraints. The data is present in 2 seperate lines, where the record number is present in the frist line and the Oracle Error in the subsequent line
I need to get the values
as follows in a file
1
5
7
because these are the record numbers of the rows having unique constraint errors.
I would like to know how to do it in shell scripting.
10 More Discussions You Might Find Interesting
1. Programming
Please Help me
I have a Bulk file containing Hex data
I want to read specific lines from that bulk file by ID number.
example
ID DATE Time data
14 2005/09/28 07:40:08.546 0 5 078B1C 01916C 0FE59C 004B54 0A9670 0D04ED 05B6B4 0E2223... (10 Replies)
Discussion started by: rajan_ka1
10 Replies
2. Shell Programming and Scripting
Dear All,
I need a unix script that will read the 7th line and especially these fileds from a file Mo speed 16, Mt speed 15 every 15 minutes starting from 00:00 to 23:45 on daily basis and put the result in a txt file and name it MT_MO_20090225.txt, please also note that the system date format... (2 Replies)
Discussion started by: samura
2 Replies
3. Shell Programming and Scripting
Hi ,
I am currently using the while loop in bash shell, as follows.
while read line
do
echo $line
done < file.txt
However, i want to use the while loop on file.txt, which will read the file with 4 lines of gap.
Ex- if file.txt is a file of 100 lines, then i want to use the loop such... (3 Replies)
Discussion started by: jitendriya.dash
3 Replies
4. Shell Programming and Scripting
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|... (4 Replies)
Discussion started by: srimal
4 Replies
5. Shell Programming and Scripting
I'm learning about the read command and wrote this little script to read data from a file:
readfile()
{
while read variable; do
echo $variable
done
}
readfile < File.txt
I have three lines in File.txt; each a single word. The script only echoes the first two lines and drops the... (9 Replies)
Discussion started by: Straitsfan
9 Replies
6. UNIX for Dummies Questions & Answers
hello!
I am trying to use sed to copy specific set of lines from a file for which the starting and ending line numbers of the lines to be copied are stored in shell variables. How can i copy those lines?
if the input_file is something like this
and if the following is the script
a=2
b=4... (4 Replies)
Discussion started by: a_ba
4 Replies
7. Shell Programming and Scripting
I have a text file which is having 30000 lines in it. I have to create a xml file for each 10000 lines until all the lines in the text files are written. Also please help how can i get number of lines in the text file in a shell variable? (19 Replies)
Discussion started by: vel4ever
19 Replies
8. Shell Programming and Scripting
Hello
My problem is that I want to change some specific numbers in a file. It is like,
2009 10 3 2349 21.3 L 40.719 27.388 10.8 FRO 7 0.8 1.1LFRO 2.6CFRO 1.1LMAM1
GAP=157 1.69 5.7 5.9 5.8 0.5405E+01 0.4455E+00 0.1653E+02E
STAT SP IPHASW D HRMM SECON CODA AMPLIT... (11 Replies)
Discussion started by: miriammiriam
11 Replies
9. Shell Programming and Scripting
I have a text file
First title line
name1
name2
name3
name4
(etc)
other lines
other lines
other lines
I want to read in this text file and parse the name1...name4 to a variable. How do I specificially read in these lines and these lines only? (10 Replies)
Discussion started by: piynik
10 Replies
10. UNIX for Dummies Questions & Answers
sxsaaas (3 Replies)
Discussion started by: VikrantD
3 Replies
LEARN ABOUT MOJAVE
mail::spf::v1::record5.18
Mail::SPF::v1::Record(3) User Contributed Perl Documentation Mail::SPF::v1::Record(3)
NAME
Mail::SPF::v1::Record - SPFv1 record class
SYNOPSIS
See Mail::SPF::Record.
DESCRIPTION
An object of class Mail::SPF::v1::Record represents an SPFv1 ("v=spf1") record.
Constructors
The following constructors are provided:
new(%options): returns Mail::SPF::v1::Record
Creates a new SPFv1 record object.
%options is a list of key/value pairs representing any of the following options:
text
terms
global_mods
See "new" in Mail::SPF::Record.
scopes
See "new" in Mail::SPF::Record. Since SPFv1 records always implicitly cover the "helo" and "mfrom" scopes, this option must either
be exactly ['helo', 'mfrom'] (or ['mfrom', 'helo']) or be omitted.
new_from_string($text, %options): returns Mail::SPF::v1::Record; throws Mail::SPF::ENothingToParse, Mail::SPF::EInvalidRecordVersion,
Mail::SPF::ESyntaxError
Creates a new SPFv1 record object by parsing the string and any options given.
Class methods
The following class methods are provided:
version_tag_pattern: returns Regexp
Returns a regular expression that matches a version tag of 'v=spf1'.
default_qualifier
results_by_qualifier
See "Class methods" in Mail::SPF::Record.
Instance methods
The following instance methods are provided:
text
scopes
terms
global_mods
global_mod
stringify
eval
See "Instance methods" in Mail::SPF::Record.
version_tag: returns string
Returns 'v=spf1'.
SEE ALSO
Mail::SPF, Mail::SPF::Record, Mail::SPF::Term, Mail::SPF::Mech, Mail::SPF::Mod
<http://tools.ietf.org/html/rfc4408>
For availability, support, and license information, see the README file included with Mail::SPF.
AUTHORS
Julian Mehnle <julian@mehnle.net>, Shevek <cpan@anarres.org>
perl v5.18.2 2017-10-06 Mail::SPF::v1::Record(3)