Sponsored Content
Top Forums Shell Programming and Scripting Capturing the invalid records to error file Post 302519543 by shruthidwh on Wednesday 4th of May 2011 09:13:08 AM
Old 05-04-2011
That was a sample data, below data will be clear.

source data
Code:
Tableid,table.txt
sourceid,ods,edw,edwh
targetid,ods,edw,edwh
Tableid,table
sourceid,ods,edw,edwh
targetid,ods,edw,edwh
Tableid,table.txt
sourceid,abc,xyz,abc
targetid,abc,xyz,abc
Tableid,table.txt
sourceid,ods,edw,edwh
targetid,ods,edw,edwh
Tableid,table
sourceid,abc,xyz,abc
targetid,abc,xyz,abc

Target data
Code:
Tableid,table
sourceid,ods,edw,edwh
targetid,ods,edw,edwh
Tableid,table
sourceid,abc,xyz,abc
targetid,abc,xyz,abc

Basically I am trying to do a exception handling..records with no valid extension that whole bunch I am dumping in a error file

Moderator's Comments:
Mod Comment Please use [code] and [/code] tags when posting code, data or logs etc. to preserve formatting and enhance readability, thanks.

Last edited by zaxxon; 05-04-2011 at 10:18 AM.. Reason: code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Count No of Records in File without counting Header and Trailer Records

I have a flat file and need to count no of records in the file less the header and the trailer record. I would appreciate any and all asistance Thanks Hadi Lalani (2 Replies)
Discussion started by: guiguy
2 Replies

2. Shell Programming and Scripting

Error while appending records to a file

Hi, I have a sample file which contains records. Input File : 1 user1 username1\password@database-name 2 user2 username2\password@database-name 3 user3 username1\password@database-name I should search for a 'username1\' in those records. If 'username1\' is found in those records, that record... (7 Replies)
Discussion started by: siri_886
7 Replies

3. Shell Programming and Scripting

Capturing multi-line records containing known value?

Some records in a file look like this, with any number of lines between start and end flags: /Start Some stuff Banana 1 Some more stuff End/ /Start Some stuff End/ /Start Some stuff Some more stuff Banana 2 End/ ...how would I process this file to find records containing the... (8 Replies)
Discussion started by: cs03dmj
8 Replies

4. Shell Programming and Scripting

01.30 Invalid shell error

Hi, I am getting the error 01.30 Invalid shell error I am running the bash shell script in the korn login shell. I have mentioned the #!/bin/bash statement in the my script but not sure why it is giving this error to me.. (4 Replies)
Discussion started by: mr_harish80
4 Replies

5. UNIX for Dummies Questions & Answers

Grep specific records from a file of records that are separated by an empty line

Hi everyone. I am a newbie to Linux stuff. I have this kind of problem which couldn't solve alone. I have a text file with records separated by empty lines like this: ID: 20 Name: X Age: 19 ID: 21 Name: Z ID: 22 Email: xxx@yahoo.com Name: Y Age: 19 I want to grep records that... (4 Replies)
Discussion started by: Atrisa
4 Replies

6. Shell Programming and Scripting

Deleting duplicate records from file 1 if records from file 2 match

I have 2 files "File 1" is delimited by ";" and "File 2" is delimited by "|". File 1 below (3 record shown): Doc1;03/01/2012;New York;6 Main Street;Mr. Smith 1;Mr. Jones Doc2;03/01/2012;Syracuse;876 Broadway;John Davis;Barbara Lull Doc3;03/01/2012;Buffalo;779 Old Windy Road;Charles... (2 Replies)
Discussion started by: vestport
2 Replies

7. Shell Programming and Scripting

Extract error records based on specific criteria from Unix file

Hi, I look for a awk one liner for below issue. input file ABC 1234 abc 12345 ABC 4567 678 XYZ xyz ght 678 ABC 787 yyuu ABC 789 7890 777 zxr hyip hyu mno uii 678 776 ABC ty7 888 All lines should be started with ABC as first field. If a record has another value for 1st... (7 Replies)
Discussion started by: ratheesh2011
7 Replies

8. Red Hat

Can't chgrp. Error - chgrp: changing group of `<file>': Invalid argument

I found that I cannot chgrp for some reason with error: chgrp: changing group of `<file>': Invalid argument This happens on all NFS mounted disks on client machines. We use AD (not my call) for authentication and it also provides groups. We have a NFS server running Scientific Linux 6.3... (1 Reply)
Discussion started by: venmx
1 Replies

9. Shell Programming and Scripting

Separate records of a file on 2 types of records

Hi I am new to shell programming in unix Please if I can provide help. I have a file structure of a header record and "N" detail records. The header record will be the total number of detail records I need to split the file in 2: One for the header Another for all detail records Could... (1 Reply)
Discussion started by: jamcogar
1 Replies

10. Shell Programming and Scripting

How to get the Invalid records from a file using awk?

My Input file is fixed length record ends with . as end of the line and the character length is 4156 Example: 12234XYZ TY^4253$+00000-00000........... I need to check is there any control characters(like ^M,^Z) The line will be splitted awk '{id=substr($0,1,5) nm=substr($0,6,3)... (2 Replies)
Discussion started by: dineshaila
2 Replies
ods-enforcerd(8)					     OpenDNSSEC ods-enforcerd						  ods-enforcerd(8)

NAME
ods-enforcerd - OpenDNSSEC Policy Enforcer daemon SYNOPSIS
ods-enforcerd [-c FILE] [-d] [-1] [-P PIDFILE] [-v] [-h] DESCRIPTION
ods-enforcerd is part of the OpenDNSSEC software. It will enforce any policies that you have set up for zones under the control of OpenDNSSEC (including the generation of keys if configured to). For more information, go to http://www.opendnssec.org and visit the Docu- mentation page. Invoked with no arguments, ods-enforcerd will read the default configuration file /etc/opendnssec/conf.xml and act according to its con- tents. OPTIONS
-c FILE Use alternate conf.xml. -d Run in debug mode. -1 Run once, then exit. -P PIDFILE Use alternate process-id file. -v Print the version, then exit. -h Show help, then exit. SIGNALS
The ods-enforcerd can be controlled using the ods-control utility. Signals may also be used. SIGHUP ods-enforcerd runs on a schedule defined in conf.xml; this signal will interrupt that and force the daemon to wake up. SIGINT, SIGTERM Force the daemon to stop (if it is running it will finish what it is doing first). CONFIGURATION
The configuration of ods-enforcerd is contained in the conf.xml file; the options available are described in the OpenDNSSEC documentation. DIAGNOSTICS
will log all the problems via the standard syslog(8) daemon facility. FILES
/etc/opendnssec/conf.xml default configuration file. /var/run/opendnssec/zone_fetcher.pid default process-id file. SEE ALSO
ods-auditor(1), ods-control(8), ods-hsmspeed(1), ods-hsmutil(1), ods-kaspcheck(1), ods-ksmutil(1), ods-signer(8), ods-signerd(8), ods-tim- ing(5), opendnssec(7), http://www.opendnssec.org/ AUTHORS
ods-enforcerd was written by John Dickinson and Nominet as part of the OpenDNSSEC project. OpenDNSSEC February 2010 ods-enforcerd(8)
All times are GMT -4. The time now is 09:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy