Sponsored Content
Top Forums Shell Programming and Scripting Grep/Awk on 1st 2 Letters in 2nd Column of File Post 302727651 by TheNovice on Tuesday 6th of November 2012 02:41:59 PM
Old 11-06-2012
Hey guys. Thanks for the quick replies. I tried the suggestions below on the acutal file (~40000 entries) and, after cross checking the output with another source, I appeared to get the most accurate results with Guru's code (awk '$2 ~ /^CA/' file).

I'll be making note of all of the suggestions below for future reference, though.

Thanks again! You guys just saved me a bunch of time.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk+Grep Input file needs to match a column and print the entire line

I'm having problems since few days ago, and i'm not able to make it works with a simple awk+grep script (or other way to do this). For example, i have a input file1.txt: cat inputfile1.txt 218299910417 1172051195 1172070231 1172073514 1183135117 1183135118 1183135119 1281440202 ... (3 Replies)
Discussion started by: poliver
3 Replies

2. Shell Programming and Scripting

grep data on 2nd line and 3rd column

How do I grep/check the on-hand value on the second line of show_prod script below? In this case it's a "3". So if it's > 0, then run_this, otherwise, quit. > ./show_prod Product Status Onhand Price shoe OK 3 1.1 (6 Replies)
Discussion started by: joker_789us
6 Replies

3. UNIX for Dummies Questions & Answers

Grep /Awk letters X - X in every line and print it as a mac address

hey i m kinda new to this so i will appreciate any help , i have this list of values: pwwn = 0x50012482009cd7a7 nwwn=0x50012482009cd7a6 port_id = 0x280200 pwwn = 0x5001248201bcd7a7 nwwn=0x5001248201bcd7a6 port_id = 0x280300 pwwn = 0x50012482009c51ad nwwn=0x50012482009c51ac port_id =... (4 Replies)
Discussion started by: boaz733
4 Replies

4. UNIX for Dummies Questions & Answers

Grep.Need help with finding the words which start at [A-K] letters in thesecond column of the table

Hi buddies ! I need some help with one grep command :) I have this table: 1 Petras Pavardenis 1980 5 08 Linas Bajoriunas 1970 10 3 Saulius Matikaitis 1982 2 5 Mindaugas Stulgis 1990... (1 Reply)
Discussion started by: vaidastf
1 Replies

5. Shell Programming and Scripting

Calculate 2nd Column Based on 1st Column

Dear All, I have input file like this. input.txt CE2_12-15 3950.00 589221.0 9849709.0 768.0 CE2_12_2012 CE2_12-15 3949.00 589199.0 9849721.0 768.0 CE2_12_2012 CE2_12-15 3948.00 589178.0 9849734.0 768.0 CE2_12_2012 CE2_12-52 1157.00 ... (3 Replies)
Discussion started by: attila
3 Replies

6. Shell Programming and Scripting

How to awk or grep the last column in file when date on column contains spaces?

Hi have a large spreadsheet which has 4 columns APM00111803814 server_2 96085 Corp IT Desktop and Apps APM00111803814 server_2 96085 Corp IT Desktop and Apps APM00111803814 server_2 96034 Storage Mgmt Team APM00111803814 server_2 96152 GWP... (6 Replies)
Discussion started by: kieranfoley
6 Replies

7. UNIX for Dummies Questions & Answers

Grep -v value in 2nd column

Trying to do a grep -v on a value in the 2nd column of text. So if the word apple appears in a line in the 2nd column, it would not show up when the file was cat. Seems like a simple enough operation but I just can't figure it out. Any help would be appreciated. Thanks in advance. Are apples... (4 Replies)
Discussion started by: jimmyf
4 Replies

8. Linux

Print the 1st column and the value in 2nd or 3rd column if that is different from the values in 1st

I have file that looks like this, DIP-17571N|refseq:NP_651151 DIP-17460N|refseq:NP_511165|uniprotkb:P45890 DIP-17571N|refseq:NP_651151 DIP-19241N|refseq:NP_524261 DIP-19241N|refseq:NP_524261 DIP-17151N|refseq:NP_524316|uniprotkb:O16797 DIP-19588N|refseq:NP_731165 ... (2 Replies)
Discussion started by: Syeda Sumayya
2 Replies

9. UNIX for Beginners Questions & Answers

Compare 1st column from 2 file and if match print line from 1st file and append column 7 from 2nd

hi I have 2 file with more than 10 columns for both 1st file apple,0,0,0...... orange,1,2,3..... mango,2,4,5..... 2nd file apple,2,3,4,5,6,7... orange,2,3,4,5,6,8... watermerlon,2,3,4,5,6,abc... mango,5,6,7,4,6,def.... (1 Reply)
Discussion started by: tententen
1 Replies
Hunspell(3pm)						User Contributed Perl Documentation					     Hunspell(3pm)

NAME
Text::Hunspell - Perl interface to the GNU Hunspell library SYNOPSIS
# For this example to work, you have to have # the US english dictionary installed! use strict; use warnings; use Data::Dumper (); use Text::Hunspell; # You can use relative or absolute paths. my $speller = Text::Hunspell->new( "/usr/share/hunspell/en_US.aff", # Hunspell affix file "/usr/share/hunspell/en_US.dic" # Hunspell dictionary file ); die unless $speller; # Check a word against the dictionary my $word = 'opera'; print $speller->check($word) ? "'$word' found in the dictionary " : "'$word' not found in the dictionary! "; # Spell check suggestions my $misspelled = 'programmng'; my @suggestions = $speller->suggest($misspelled); print " ", "You typed '$misspelled'. Did you mean? "; for (@suggestions) { print " - $_ "; } # Analysis of a word $word = 'automatic'; my $analysis = $speller->analyze($word); print " ", "Analysis of '$word' returns '$analysis' "; # Word stemming $word = 'development'; my @stemming = $speller->stem($word); print " ", "Stemming of '$word' returns: "; for (@stemming) { print " - $_ "; } #------------------------------------------ # ADVANCED STUFF FROM HERE # NOT SURE HOW IT SHOULD WORK #------------------------------------------ # # Test here generator for morphological modification (NOM->ACC) # $word = 'developer'; my $stem = 'computer'; @suggestions = $speller->analyze($stem); # Modify analyze output for required class (ACC) for (@suggestions) { s/NOM/ACC/g; } # Generate ACC class of stem @suggestions = $speller->generate2($stem, @suggestions); print "Morphological modification generator... "; print Data::Dumper::Dumper(@suggestions); # # Test generator for morphological modification, # modify $stem like $word # @suggestions = $speller->generate($stem, $word); print "Morphological modification generator... "; print Data::Dumper::Dumper(@suggestions); # Deletes the underlying Hunspell C/C++ object $speller->delete($speller); DESCRIPTION
This module provides a Perl interface to the OO Hunspell library. This module is to meet the need of looking up many words, one at a time, in a single session, such as spell-checking a document in memory. The example code describes the interface on http://hunspell.sf.net DEPENDENCIES
You MUST have installed GNU Hunspell library version 1.0 or higher on your system before installing this "Text::Hunspell" Perl module. Hunspell location is: http://hunspell.sf.net There have been a number of bug reports because people failed to install hunspell before installing this module. This is an interface to the hunspell library installed on your system, not a replacement for hunspell. You must also have one hunspell dictionary installed when running the module's test suite. Also, please see the README and Changes files. README may have specific information about your platform. METHODS
The following methods are available: "Text::Hunspell-"new($full_path_to_affix, $full_path_to_dic)> Creates a new speller object. Parameters are: full path of affix file full path of dictionary (dic) file Returns "undef" if the object could not be created, which is unlikely. "check($word)" Check the word. Returns 1 if the word is found, 0 otherwise. "suggest($misspelled_word)" Returns the list of suggestions for the misspelled word. "analyze($word)" Returns the analysis list for the word. TODO HOW? What does it return?? See the examples in the examples/ folder for now. "stem($word)" Returns the stem list for the word. "generate2($stem, @suggestions)" Returns a morphologically modified stem as defined in @suggestions (got by analysis). TODO Explain ... "generate($stem, $word)" Returns morphologically modified stem like $word. TODO WHY IS THIS DIFFERENT FROM generate2() ??? EXPLAIN. "$speller-"delete($speller)> Deletes the speller class. TODO WHY IS THIS NEEDED?? Called on $speller and needs $speller ??? BUGS
Probably. Yes, definitely. COPYRIGHT
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. AUTHORS
Eleonora, E<lt>eleonora46_at_gmx_dot_netE<gt> Current maintainer is: Cosimo Streppone, E<lt>cosimo@cpan.orgE<gt> This module is based on a Text::Aspell written by Bill Moseley moseley at hank dot org. Hunspell is written as myspell by Kevin B. Hendricks. Hunspell is maintained by Nemeth Laszlo. Please see: http://hunspell.sf.net For the dictionaries: http://lingucomponent.openoffice.org/spell_dic.html http://magyarispell.sf.net for Hungarian dictionary perl v5.14.2 2012-06-07 Hunspell(3pm)
All times are GMT -4. The time now is 08:14 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy