Sponsored Content
Top Forums Shell Programming and Scripting How to get some data in the file? Post 302750955 by pmreddy on Thursday 3rd of January 2013 01:39:59 AM
Old 01-03-2013
How to get some data in the file?

Hi all,

I have a log file with the below data.
I want to get only the red colored data from log file.

Record ----: Rejected may varies from one file to another file.

Please help me how to get some data in the file

Code:
Record 4466: Discarded - failed all WHEN clauses.
Record 4467: Discarded - failed all WHEN clauses.
Record 1632: Rejected - Error on table NOR_DATA, column COMPANY_NUM.
 ORA-01722: invalid number
Record 1659: Rejected - Error on table NOR_DATA, column COMPANY_NUM
 ORA-01722: invalid number
  
Table NOR_DATA:
   40 Rows successfully loaded.
   2 Rows not loaded due to data errors.
   4425 Rows not loaded because all WHEN clauses were failed.
   0 Rows not loaded because all fields were null.
  
  
Space allocated for bind array:               40958016 bytes(7216 rows)
 Read   buffer bytes:40960000
  
 
Total logical records skipped:          0
Total logical records read:          4467
Total logical records rejected:         2
Total logical records discarded:     4425
 

Run began on Thu Jan 03 01:14:50 2013
Run ended on Thu Jan 03 01:14:50 2013

 
Elapsed time was:     00:00:00.39
CPU time was:         00:00:00.23


Last edited by Scrutinizer; 01-03-2013 at 07:36 AM.. Reason: code tags
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Using loop reading a file,retrieving data from data base.

Hi All, I am having trouble through, I am reading the input from tab delimited file containing several records, e.g. line1 field1 field2 field3 so on.. line2 field1 field2 field3 so on.. .. .. on the basis of certain fields for each record in input file, I have to retrieve... (1 Reply)
Discussion started by: Sonu4lov
1 Replies

2. Shell Programming and Scripting

Find and replace data in text file with data in same file

OK I will do my best to explain what I need help with. I am trying to format an ldif file so I can import it into Oracle oid. I need the file to look like this example. Keep in mind there are 3000 of these in the file. changetype: modify replace: userpassword dn:... (0 Replies)
Discussion started by: timothyha22
0 Replies

3. UNIX for Dummies Questions & Answers

How to get data only inside polygon created by points which is part of whole data from file?

hiii, Help me out..i have a huge set of data stored in a file.This file has has 2 columns which is latitude & longitude of a region. Now i have a program which asks for the number of points & based on this number it asks the user to enter that latitude & longitude values which are in the same... (7 Replies)
Discussion started by: reva
7 Replies

4. UNIX for Dummies Questions & Answers

Mapping a data in a file and delete line in source file if data does not exist.

Hi Guys, Please help me with my problem here: I have a source file: 1212 23232 343434 ASAS1 4 3212 23232 343434 ASAS2 4 3234 23232 343434 QWQW1 4 1134 23232 343434 QWQW2 4 3212 23232 343434 QWQW3 4 and a mapping... (4 Replies)
Discussion started by: kokoro
4 Replies

5. Shell Programming and Scripting

Generate tabular data based on a column value from an existing data file

Hi, I have a data file with : 01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083 I... (1 Reply)
Discussion started by: himanish
1 Replies

6. Shell Programming and Scripting

Extract header data from one file and combine it with data from another file

Hi, Great minds, I have some files, in fact header files, of CTD profiler, I tried a lot C programming, could not get output as I was expected, because my programming skills are very poor, finally, joined unix forum with the hope that, I may get what I want, from you people, Here I have attached... (17 Replies)
Discussion started by: nex_asp
17 Replies

7. Shell Programming and Scripting

Replace data of a file with data from another file using shell scripting.

Dears, I'm new to shell scripting and i was wondering if you can help me with following matter. I have a file containing 400,000 records. The file contains two columns like: 00611291,0270404000005453 25262597,1580401000016155 25779812,1700403000001786 00388934,1200408000000880... (1 Reply)
Discussion started by: paniklas
1 Replies

8. Shell Programming and Scripting

awk --> math-operation in data-record and joining with second file data

Hi! I have a pretty complex job - at least for me! i have two csv-files with meassurement-data: fileA ...... (2 Replies)
Discussion started by: IMPe
2 Replies

9. Shell Programming and Scripting

In PErl script: need to read the data one file and generate multiple files based on the data

We have the data looks like below in a log file. I want to generat files based on the string between two hash(#) symbol like below Source: #ext1#test1.tale2 drop #ext1#test11.tale21 drop #ext1#test123.tale21 drop #ext2#test1.tale21 drop #ext2#test12.tale21 drop #ext3#test11.tale21 drop... (5 Replies)
Discussion started by: Sanjeev G
5 Replies
srec_aomf(5)							File Formats Manual						      srec_aomf(5)

NAME
srec_aomf - Intel Absolute Object Module Format DESCRIPTION
The Absolute Object Module Format (AOMF) is a subset of the 8051 OMF. The structure of an absolute object file (the order of the records in it) is similar to that of a relocatable object file. There are three main differences: the first is that an absolute object file con- tains one module only, the second is that not all the records can appear in the absolute file and the third is that the records can contain only absolute information. Generic Record Format Each record starts with a record type which indicates the type of the record, and record length which contain the number of bytes in the record exclusive of the first two fields. The record ends with a checksum byte which contains the 2s complement of the sum (modulo 256) of all other bytes in the record. Therefore the sum (modulo 256) of all bytes in the record is zero. The record length includes the payload and checksum fields, but excludes the type and length fields. All 16-bit fields are little-endian. +--------+---------+---------+---------+ |REC | Record | Payload | CHK | |TYP | Length | | SUM | |8 bits | 16 bits | | 8 bits | +--------+---------+---------+---------+ Here are some of the relevant record types: 0x01 Scope Definition Record 0x02 Module Start Record 0x04 Module End Record 0x06 Content Record 0x0E Segment Definition Record 0x12 Debug Items Record 0x16 Public Definition Record 0x18 External Definition Record Names are not stored a C strings. Names are stored as a length byte followed by the contents. Structure An AOMF file consists of a module header record (0x02), followed by one or more content (0x06), scope (0x01) or debug (0x12) records, and ends in a module end record (0x04). The records with the following types are extraneous (they may appear in the file but are ignored): 0x0E, 0x16 and 0x18 (definition records). All records which are not part of the AOMF and are not extraneous are considered erroneous. Module Header Record +--------+---------+---------+---------+---------+---------+ | REC | Record | Module | TRN ID | zero | CHK | | TYP | Length | Name | 8 bits | 8 bits | SUM | | 0x02 | 16 bits | | | | 8 bits | +--------+---------+---------+---------+---------+---------+ Each module must starts with a module header record. It is used to identify the module for the RL51 and other future processors of 8051 object files. In addition to the Module Name the record contains: TRN ID The byte identifies the program which has generated this module: 0xFD ASM51 0xFE PL/M-51 0xFF RL51. Module End Record +--------+---------+---------+---------+---------+---------+---------+ | REC | Record | Module | zero | REG | zero | CHK | | TYP | Length | Name | 16 bits | MSK | 8 bits | SUM | | 0x04 | 16 bits | | | 8 bits | | 8 bits | +--------+---------+---------+---------+---------+---------+---------+ The record ends the module sequence and contains the following information: characteristics MODULE NAME The name of the module is given here for a consistency check. It must match the name given in the Module Header Record. REGISTER MASK (REG MSK) The field contains a bit for each of the four register banks. Each bit, when set specifies that the corresponding bank is used by the module: Bit 0 (the least significant bit) bank #0. Bit 1 bank #1. Bit 2 bank #2. Bit 3 bank #3. Content Record +--------+---------+---------+---------+---------+---------+ | REC | Record | SEG ID | Offset | DATA | CHK | | TYP | Length | 8 bits | 16 bits | | SUM | | 0x06 | 16 bits | | | | 8 bits | +--------+---------+---------+---------+---------+---------+ This record provides one or more bytes of contiguous data, from which a portion of a memory image may be constructed. SEG ID This field must be zero. OFFSET Gives the absolute address of the first byte of data in the record, within the CODE address space. DATA A sequence of data bytes to be loaded from OFFSET to OFFSET+RECORDLENGTH-5. Size Multiplier In general, raw binary data will expand in sized by approximately 1.02 times when represented with this format. SOURCE
http://www.intel.com/design/mcs96/swsup/omf96_pi.pdf ftp://download.intel.com/design/mcs51/SWSUP/omf51.exe (zip archive) http://www.elsist.net/WebSite/ftp/various/OMF51EPS.pdf COPYRIGHT
srec_cat version 1.58 Copyright (C) 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011 Peter Miller The srec_cat program comes with ABSOLUTELY NO WARRANTY; for details use the 'srec_cat -VERSion License' command. This is free software and you are welcome to redistribute it under certain conditions; for details use the 'srec_cat -VERSion License' command. AUTHOR
Peter Miller E-Mail: pmiller@opensource.org.au //* WWW: http://miller.emu.id.au/pmiller/ Reference Manual SRecord srec_aomf(5)
All times are GMT -4. The time now is 02:54 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy