Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need to Extract Data From 94000 records
Top Forums Shell Programming and Scripting Need to Extract Data From 94000 records Post 302306812 by summer_cherry on Monday 13th of April 2009 11:02:29 PM
Old 04-14-2009
perl:

Code:
open $fh,"<","a.txt";
while(<$fh>){
	if (/STARTTLS=server/){
		my @arr=split(" ",$_) ;
		my @brr=split("[.]",$arr[$#arr]);
		my $temp=sprintf("%s.%s",$brr[$#brr-1],$brr[$#brr]);
		$hash{$temp}=1;
	}
}
print join "\n", sort keys %hash;

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extract set of matching records

i have a pipe delimited file with records spread in many lines. i need to extract those records 1)having X in beginning of that record 2)and having at least one Y in beginning before other record begins eg: X|Rec1| A|Rec1| Y|Rec1| X|Rec2| Y|Rec2| Z|Rec3| X|Rec4| M|Rec4| ... (4 Replies)
Discussion started by: finder255
4 Replies

2. Shell Programming and Scripting

Extract data from large file 80+ million records

Hello, I have got one file with more than 120+ million records(35 GB in size). I have to extract some relevant data from file based on some parameter and generate other output file. What will be the besat and fastest way to extract the ne file. sample file format :--... (2 Replies)
Discussion started by: learner16s
2 Replies

3. Shell Programming and Scripting

Extract data based on match against one column data from a long list data

My input file: data_5 Ali 422 2.00E-45 102/253 140/253 24 data_3 Abu 202 60.00E-45 12/23 140/23 28 data_1 Ahmad 256 7.00E-45 120/235 140/235 22 data_4 Aman 365 8.00E-45 15/65 140/65 20 data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies

4. Shell Programming and Scripting

Extract CSV records using NAWK?

Example CSV: $ cat myfile HDR COL_A,COL_B,COL_C X,Y,Z Z,Y,X ... X,W,Z In this example, I know that column names are on the second line. I also know that I would like to print lines where COL_A="X" and COL_C="Z". In this simple example, I know that COL_A = $1 and COL_C = $3, and hence... (6 Replies)
Discussion started by: cs03dmj
6 Replies

5. Shell Programming and Scripting

Extract data from records that match pattern

Hi Guys, I have a file as follows: a b c 1 2 3 4 pp gg gh hh 1 2 fm 3 4 g h i j k l m 1 2 3 4 d e f g h j i k l 1 2 3 f 3 4 r t y u i o p d p re 1 2 3 f 4 t y w e q w r a s p a 1 2 3 4 I am trying to extract all the 2's from each row. 2 is just an example... (6 Replies)
Discussion started by: npatwardhan
6 Replies

6. Shell Programming and Scripting

Compare Records between to files and extract it

I am not an expert in awk, SED, etc... but I really hope there is a way to do this, because I don't want to have to right a program. I am using C shell. FILE 1 FILE 2 H0000000 H0000000 MA1 MA1 CA1DDDDDD CA1AAAAAA MA2 ... (2 Replies)
Discussion started by: jclanc8
2 Replies

7. Shell Programming and Scripting

ksh coding to extract records from file

Hello, I have a file with various records in it (from length 30 - 195) and I want to run a script to read each line and copy only the recl=80 files to an output file. Any help much appreciated (4 Replies)
Discussion started by: Grueben
4 Replies

8. Shell Programming and Scripting

Extract records from list

Hi Gents, I have a file 1 like this 1 1000 20 2 2000 30 3 1000 40 5 1000 50 And I have other file 1 like 2 1 I would like to get from the file 1 the complete line which are in file 2, the key to compare is the column 2 then output should be. 2 2000 30. I was trying to get it... (5 Replies)
Discussion started by: jiam912
5 Replies

9. Shell Programming and Scripting

Extract UNIque records from File

Hi, I have a file with 20GB Pipe Delimited file where i have too many duplicate records. I need an awk script to extract the unique records from the file and put it into another file. Kindly help. Thanks, Arun (1 Reply)
Discussion started by: Arun Mishra
1 Replies

10. Shell Programming and Scripting

Extract Matched Records from XML

Hi All, I have a requirement to extract para in XML file on the basis of another list file having specific parameters. I will extract these para from XML and import in one scheduler tool. file2 <FOLDER DATACENTER="ControlMserver" VERSION="800" PLATFORM="UNIX" FOLDER_NAME="SH_AP_INT_B01"... (3 Replies)
Discussion started by: looney
3 Replies

LEARN ABOUT DEBIAN

icns2png

ICNS2PNG(1)							   User Commands						       ICNS2PNG(1)

NAME

       icns2png - convert Mac OS icns files to png images

SYNOPSIS

       icns2png [-x|-l] [options] [file ... ]

DESCRIPTION

       icns2png extracts images from mac .icns files, and exports them to png format.

OPTIONS

       -l, --list
	      List the contents of one or more icns images

       -x, --extract Extract one or more icons to png images

       -o, --output
	      Where to place extracted files. If not specified, icons will be extracted to the same path as the source file.

       -d, --depth
	      Sets the pixel depth of the icons to extract. (1,4,8,32)

       -s, --size
	      Sets the width and height of the icons to extract. (16,48,etc) Sizes 16x12, 16x16, 32x32, 48x48, 128x128, etc. are also valid.

       -h, --help
	      Displays this help message.

       -v, --version Displays the version information

EXAMPLES

       icns2png -x anicon.icns		  # Extract all icon found in anicon.icns
       icns2png -x -s 48 anicon.icns	  # Extract all 48x48 32-bit icons
       icns2png -x -s 32 -d 1 anicon.icns # Extract all 32x32 1-bit icons
       icns2png -l anicon.icns		  # Lists the icons contained in anicon.icns

AUTHOR

       Written by Mathew Eis

COPYRIGHT

       Copyright (C) 2001-2008 Mathew Eis
       This is free software; see the source for copying conditions.  There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
       LAR PURPOSE.

icns2png 1.5							    March 2008							       ICNS2PNG(1)
All times are GMT -4. The time now is 12:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy