Removing bad records from a text file Post: 302398471

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

problem with bad records

I have a data file with around 1 million records and i have 12 data fileds in each record seperated by 11 pipes. The file also has some bad records where there is only one pipe in some of the records. I want to print all this records with only one pipe in them. These bad records are broken...

2. UNIX for Advanced & Expert Users

Duplicate records from oracle to text file.

Hi, I want to fetch duplicate records from an external table to a text file. Pls suggest me. Thanks

3. Shell Programming and Scripting

How to findDuplicate Records in a text file

Pls Any one help me in

4. Shell Programming and Scripting

How to find Duplicate Records in a text file

Hi all pls help me by providing soln for my problem I'm having a text file which contains duplicate records . Example: abc 1000 3452 2463 2343 2176 7654 3452 8765 5643 3452 abc 1000 3452 2463 2343 2176 7654 3452 8765 5643 3452 tas 3420 3562 ...

5. Shell Programming and Scripting

Removing duplicate records in a file based on single column

Hi, I want to remove duplicate records including the first line based on column1. For example inputfile(filer.txt): ------------- 1,3000,5000 1,4000,6000 2,4000,600 2,5000,700 3,60000,4000 4,7000,7777 5,999,8888 expected output: ---------------- 3,60000,4000 4,7000,7777...

6. Shell Programming and Scripting

removing file with bad characters

I have the following files in the same directory but if you look at the od output you can see one of the files has and "\n" as part of the file name. Is there a way I can only remove the file with the "\n" as part of the file name without affecting the other file. I was thinking about...

7. Shell Programming and Scripting

Removing duplicate records in a file based on single column explanation

I was reading this thread. It looks like a simpler way to say this is to only keep uniq lines based on field or column 1. https://www.unix.com/shell-programming-scripting/165717-removing-duplicate-records-file-based-single-column.html Can someone explain this command please? How are there no...

8. Shell Programming and Scripting

remove bad records.

HI I have a problem in a file .The file was generated with the wrong data in it. MAL 005158UK473BBTICK1120722 A9999999ADASCD 1120722ADD_SECURIADD_SECURI MAL 005158UK473BBU 1120722 A9999999FF000EA0B9C 1120722ADD_SECURIADD_SECURI MAL 005158UK473ISN 1120722 A9999999US005158UK43...

9. Shell Programming and Scripting

Remove bad records from file and move them into a file then send those via email

Hi my requirement is that i want pull the bad records from input file and move those records in to a seperate file. that file has to be sent via email.. any suggentions please

10. UNIX for Dummies Questions & Answers

Delete records based on a text file from a text file

Hi Folks, I am a novice and need to build a script in bash. I have 2 text files data.txt file is big file, column 2 is the we need to search and delete in the output. The filter file contains the rows to be deleted. Data.txt state city zone Alabama Huntsville 4 California SanDiego 3...

LEARN ABOUT DEBIAN

www::topica::reply

WWW::Topica::Reply(3pm) 				User Contributed Perl Documentation				   WWW::Topica::Reply(3pm)

NAME

       WWW::Topica::Index - parse a single Topic mailing list index

SYNOPSIS

	   my $index = WWW::Topic::Index->new($index_html);

	   foreach my $message_id ($index->message_ids) {
	       # the mail has some information and also provides a link to the reply ...
	       my $mail  = WWW::Topica::Mail->new($topica->fetch_mail($mess_id), $mess_id);
	       # which has other information (like the un-htmled mail and the email address) ...
	       my $reply = WWW::Topica::Reply->new($topica->fetch_reply($mail->id, $mail->eto), $mail->id, $mail->eto);
	   }

	   print "Next offset is ".$index->next."
";
	   print "Previous offset is ".$index->prev."
";

DESCRIPTION

       Used to parse a single reply page from Topica.com's mailing list indexes.

       Reply pages have the body of the email (albeit quoted) and potentially a full email address.

METHODS

   new <page html> <message id> <eto>
       Takes the html of the page, the eto and the message-id and parses the html.

   parse <html>
       Parse the html to get the subject, email address and body of the email.

   id
       Get the message id

   eto
       Get the message eto

   email
       Get the email address parsed out.

   subject
       Get the email subject parsed out.

   body
       Get the email body parsed out.

AUTHOR

       Simon Wistow <simon@thegestalt.org>

COPYRIGHT

       Copyright (c) 2004, Simon Wistow

perl v5.10.1							    2006-01-03						   WWW::Topica::Reply(3pm)