Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Script to search a bad record in a file then put the record in the bad file
Top Forums UNIX for Advanced & Expert Users Script to search a bad record in a file then put the record in the bad file Post 302154177 by radoulov on Friday 28th of December 2007 09:00:45 AM
Old 12-28-2007
Code:
awk 'NR==1{print>(FILENAME".bad")}
{print>($3=="N/A"?FILENAME".bad":FILENAME".fixed")}' data

Use nawk or /usr/xpg4/bin/awk on Solaris.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

splitting a record and adding a record to a file

Hi, I am new to UNIX scripting and woiuld appreicate your help... Input file contains only one (but long) record: aaaaabbbbbcccccddddd..... Desired file: NEW RECORD #new record (hardcoded) added as first record - its length is irrelevant# aaaaa bbbbb ccccc ddddd ... ... ... (1 Reply)
Discussion started by: rsolap
1 Replies

2. Shell Programming and Scripting

Script to search a bad record in a file then put the record in the bad file

I need to write a script that can find a bad record (for example: there is date field colom but value provided in the file for this field is N/A) then script shoud searches this pattern and then insert the whole record into the bad file. Example: File1 Name designation dateOfJoining... (2 Replies)
Discussion started by: shilendrajadon
2 Replies

3. UNIX for Dummies Questions & Answers

how to read record by record from a file in unix

Hi guys, i have a big file with the following format.This includes header(H),detail(D) and trailer(T) information in the file.My problem is i have to search for the character "6h" at 14 th and 15 th position in all the records .if it is there i have to write all those records into a... (1 Reply)
Discussion started by: raoscb
1 Replies

4. Shell Programming and Scripting

search and replace fixed length record file

Hi I need to be search a file of fixed length records and when I hit a particular record that match a search string, substitute a known position field In the example file below FHEAD000000000120090806143011 THEAD0000000002Y0000000012 P00000000000000001234 TTAIL0000000003... (0 Replies)
Discussion started by: nedkelly007
0 Replies

5. Shell Programming and Scripting

Bash Script to read a file and parse each record

Hi Guys, I am new to unix scripting and I am tasked to parse through a CSV file delimited by #. Sample: sample.csv H#A#B#C D#A#B#C T#A#B#C H = Header D = Detail Record T = Tail What I need is to read the file and parse through it to get the columns. I have no idea on how... (8 Replies)
Discussion started by: 3vilwyatt
8 Replies

6. Shell Programming and Scripting

Reading a file (one record) in a SHL script

I am trying to read a file in a shl script (only one record) and stored in a variable file_number I got the following read -u $BANNER_HOME/xxxxxxx/misc/EFTSQL.dat file_number file_number2 = $file_number + 1 echo $file_number2 > $BANNER_HOME/xxxxxx/misc/EFTSQL.dat EOF It is not working... (2 Replies)
Discussion started by: rechever
2 Replies

7. Shell Programming and Scripting

Searching for Log / Bad file and Reading and writing to a flat file

Need to develop a unix shell script for the below requirement and I need your assistance: 1) search for file.log and file.bad file in a directory and read them 2) pull out "Load_Start_Time", "Data_File_Name", "Error_Type" from log file 4) concatinate each row from bad file as... (3 Replies)
Discussion started by: mlpathir
3 Replies

8. Shell Programming and Scripting

Print record count of a file using shell script

HI, I need to print the record count of a file using shell script. If the record count of a file excluding header and trailer record if greater than zero then print 'Record count of a file is xxxx records'. If the record count is zero print 'zero records' Thanks Mahendra (1 Reply)
Discussion started by: mmeda
1 Replies

9. Shell Programming and Scripting

Creating repeating record in between file through script

apprecieate your help to resove this. My source file looke like 1001 000 HEADER 1001 001 RAJESH 1001 002 100 1001 002 200 1001 002 500 1001 006 FOOTER 1002 000 HEADER 1002 001 RAMESH 1002 002 100 1002 002 200 1002 002 500 1002 006 FOOTER my... (8 Replies)
Discussion started by: Ganesh L
8 Replies

10. Shell Programming and Scripting

Extract timestamp from first record in xml file and it checks if not it will replace first record

I have test.xml <emp><id>101</id><name>AAA</name><date>06/06/14 1811</date></emp> <Join><id>101</id><city>london</city><date>06/06/14 2011</date></join> <Join><id>101</id><city>new york</city><date>06/06/14 1811</date></join> <Join><id>101</id><city>sydney</city><date>06/06/14... (2 Replies)
Discussion started by: vsraju
2 Replies

LEARN ABOUT OPENSOLARIS

wtmpfix

fwtmp(1M)						  System Administration Commands						 fwtmp(1M)

NAME

       fwtmp, wtmpfix - manipulate connect accounting records

SYNOPSIS

       /usr/lib/acct/fwtmp [-ic]

       /usr/lib/acct/wtmpfix [file]...

DESCRIPTION

       fwtmp  reads  from  the	standard input and writes to the standard output, converting binary records of the type found in /var/adm/wtmpx to
       formatted ASCII records. The ASCII version is useful when it is necessary to edit  bad records.

       wtmpfix examines the standard input or named files in utmpx format, corrects the time/date stamps  to  make  the  entries  consistent,  and
       writes  to  the standard output. A hyphen (-) can be used in place of file to indicate the standard input. If time/date corrections are not
       performed, acctcon(1M) will fault when it encounters certain date-change records.

       Each time the date is set, a pair of date change records are written to /var/adm/wtmpx. The first record is the old  date  denoted  by  the
       string  "old time" placed in the line field and the flag OLD_TIME placed in the type field of the utmpx structure. The second record speci-
       fies the new date and is denoted by the string new time placed in the line field and the flag NEW_TIME placed in the  type  field.  wtmpfix
       uses these records to synchronize all time stamps in the file.

       In addition to correcting time/date stamps, wtmpfix will check the validity of the name field to ensure that it consists solely of alphanu-
       meric characters or spaces. If it encounters a name that is considered invalid, it will change the login name to INVALID and write a  diag-
       nostic to the standard error. In this way, wtmpfix reduces the chance that acctcon will fail when processing connect accounting records.

OPTIONS

       -ic    Denotes that input is in ASCII form, and output is to be written in binary form.

FILES

       /var/adm/wtmpx	 history of user access and administration information

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWaccu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       acctcom(1),  ed(1),  acct(1M),  acctcms(1M),  acctcon(1M),  acctmerg(1M),  acctprc(1M),	acctsh(1M),  runacct(1M),  acct(2), acct.h(3HEAD),
       utmpx(4), attributes(5)

SunOS 5.11							    22 Feb 1999 							 fwtmp(1M)
All times are GMT -4. The time now is 05:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy