Delete rows with unique value for specific column Post: 302654825

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Print rows, having pattern in specific column...

Hello all, :) I have a pattern file some what like this, cd003 cd005 cd007 cd008 and input file like this, abc cd001 cd002 zca bca cd002 cd003 cza cba cd003 cd004 zca bac cd004 cd005 zac cba cd005 cd006 acz acb cd006 cd007 caz cab cd007 ...

2. UNIX for Dummies Questions & Answers

Delete all rows that contain a specific string (text)

Hi, I have a text file and I want to delete all rows that contain a particular string of characters. How do I go about doing that? Thanks!

3. Shell Programming and Scripting

Delete unique rows - optimize script

Hi all, I have the following input - the unique row key is 1st column cat file.txt A response C request C response D request C request C response E request The desired output should be C request

4. Shell Programming and Scripting

Print unique names in each row of a specific column using awk

Is it possible to remove redundant names in the 4th column? input cqWE 100 200 singapore;singapore AZO 300 400 brazil;america;germany;ireland;germany .... .... output cqWE 100 200 singapore AZO 300 400 brazil;america;germany;ireland

5. UNIX for Dummies Questions & Answers

Deleting rows where the value in a specific column match

Hi, I have a tab delimited text file where I want to delete all rows that have the same string for column 1. How do I go about doing that? Thanks! Example Input: aa 1 aa 2 aa 3 bb 4 bc 5 bb 6 cd 8 Output: bc 5 cd 8

6. Shell Programming and Scripting

Print unique names in a specific column using awk

Is it possible to modify file like this. 1. Remove all the duplicate names in a define column i.e 4th col 2. Count the no.of unique names separated by ";" and print as a 5th col thanx in advance!! Q input c1 30 3 Eh2 c10 96 3 Frp c41 396 3 Ua5;Lop;Kol;Kol c62 2 30 Fmp;Fmp;Fmp ...

7. Shell Programming and Scripting

Converting Single Column into Multiple rows, but with strings to specific tab column

Dear fellows, I need your help. I'm trying to write a script to convert a single column into multiple rows. But it need to recognize the beginning of the string and set it to its specific Column number. Each Line (loop) begins with digit (RANGE). At this moment it's kind of working, but it...

8. Shell Programming and Scripting

Extract lines with unique value using a specific column

Hi there, I need a help with extracting data from tab delimited file which look like this #CHROM POS ID REF ALT Human Cow Dog Mouse Lizard chr2 3033 . G C 0/0 0/0 0/0 1/1 0/0 chr3 35040 . G T 0/0 0/0 ./. 1/1 0/1 chr4 60584 . T G 1/1 1/1 0/1 1/1 0/0 chr10 7147815 . G A 0/0 1/1 0/0 0/0...

9. Shell Programming and Scripting

Count frequency of unique values in specific column

Hi, I have tab-deliminated data similar to the following: dot is-big 2 dot is-round 3 dot is-gray 4 cat is-big 3 hot in-summer 5 I want to count the frequency of each individual "unique" value in the 1st column. Thus, the desired output would be as follows: dot 3 cat 1 hot 1 is...

10. UNIX for Dummies Questions & Answers

Removing rows that contain non-unique column entry

Background: I have a file of thousands of potential SSR primers from Batch Primer 3. I can't use primers that will contain the same sequence ID or sequence as another primer. I have some basic shell scripting skills, but not enough to handle this. What you need to know: I need to remove the...

LEARN ABOUT DEBIAN

datetime::locale::ga_ie

DateTime::Locale::ga_IE(3pm)				User Contributed Perl Documentation			      DateTime::Locale::ga_IE(3pm)

NAME

       DateTime::Locale::ga_IE - DateTime locale package for "ga_IE"

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'ga_IE' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Irish Ireland.

DATA

       This locale inherits from the DateTime::Locale::ga locale.

       It contains the following data.

   Days
       Wide (format)

	 De Luain
	 De Mairt
	 De Ceadaoin
	 Deardaoin
	 De hAoine
	 De Sathairn
	 De Domhnaigh

       Abbreviated (format)

	 Luan
	 Mairt
	 Cead
	 Dear
	 Aoine
	 Sath
	 Domh

       Narrow (format)

	 L
	 M
	 C
	 D
	 A
	 S
	 D

       Wide (stand-alone)

	 De Luain
	 De Mairt
	 De Ceadaoin
	 Deardaoin
	 De hAoine
	 De Sathairn
	 De Domhnaigh

       Abbreviated (stand-alone)

	 Luan
	 Mairt
	 Cead
	 Dear
	 Aoine
	 Sath
	 Domh

       Narrow (stand-alone)

	 L
	 M
	 C
	 D
	 A
	 S
	 D

   Months
       Wide (format)

	 Eanair
	 Feabhra
	 Marta
	 Aibrean
	 Bealtaine
	 Meitheamh
	 Iuil
	 Lunasa
	 Mean Fomhair
	 Deireadh Fomhair
	 Samhain
	 Nollaig

       Abbreviated (format)

	 Ean
	 Feabh
	 Marta
	 Aib
	 Beal
	 Meith
	 Iuil
	 Lun
	 MFomh
	 DFomh
	 Samh
	 Noll

       Narrow (format)

	 E
	 F
	 M
	 A
	 B
	 M
	 I
	 L
	 M
	 D
	 S
	 N

       Wide (stand-alone)

	 Eanair
	 Feabhra
	 Marta
	 Aibrean
	 Bealtaine
	 Meitheamh
	 Iuil
	 Lunasa
	 Mean Fomhair
	 Deireadh Fomhair
	 Samhain
	 Nollaig

       Abbreviated (stand-alone)

	 Ean
	 Feabh
	 Marta
	 Aib
	 Beal
	 Meith
	 Iuil
	 Lun
	 MFomh
	 DFomh
	 Samh
	 Noll

       Narrow (stand-alone)

	 E
	 F
	 M
	 A
	 B
	 M
	 I
	 L
	 M
	 D
	 S
	 N

   Quarters
       Wide (format)

	 1u raithe
	 2u raithe
	 3u raithe
	 4u raithe

       Abbreviated (format)

	 R1
	 R2
	 R3
	 R4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 1u raithe
	 2u raithe
	 3u raithe
	 4u raithe

       Abbreviated (stand-alone)

	 R1
	 R2
	 R3
	 R4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 Roimh Chriost
	 Anno Domini

       Abbreviated

	 RC
	 AD

       Narrow

	 RC
	 AD

   Date Formats
       Full

	  2008-02-05T18:30:30 = De Mairt 5 Feabhra 2008
	  1995-12-22T09:05:02 = De hAoine 22 Nollaig 1995
	 -0010-09-15T04:44:23 = De Sathairn 15 Mean Fomhair -10

       Long

	  2008-02-05T18:30:30 = 5 Feabhra 2008
	  1995-12-22T09:05:02 = 22 Nollaig 1995
	 -0010-09-15T04:44:23 = 15 Mean Fomhair -10

       Medium

	  2008-02-05T18:30:30 = 5 Feabh 2008
	  1995-12-22T09:05:02 = 22 Noll 1995
	 -0010-09-15T04:44:23 = 15 MFomh -10

       Short

	  2008-02-05T18:30:30 = 05/02/2008
	  1995-12-22T09:05:02 = 22/12/1995
	 -0010-09-15T04:44:23 = 15/09/-010

       Default

	  2008-02-05T18:30:30 = 5 Feabh 2008
	  1995-12-22T09:05:02 = 22 Noll 1995
	 -0010-09-15T04:44:23 = 15 MFomh -10

   Time Formats
       Full

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

       Short

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 09:05
	 -0010-09-15T04:44:23 = 04:44

       Default

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = De Mairt 5 Feabhra 2008 18:30:30 UTC
	  1995-12-22T09:05:02 = De hAoine 22 Nollaig 1995 09:05:02 UTC
	 -0010-09-15T04:44:23 = De Sathairn 15 Mean Fomhair -10 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 5 Feabhra 2008 18:30:30 UTC
	  1995-12-22T09:05:02 = 22 Nollaig 1995 09:05:02 UTC
	 -0010-09-15T04:44:23 = 15 Mean Fomhair -10 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 5 Feabh 2008 18:30:30
	  1995-12-22T09:05:02 = 22 Noll 1995 09:05:02
	 -0010-09-15T04:44:23 = 15 MFomh -10 04:44:23

       Short

	  2008-02-05T18:30:30 = 05/02/2008 18:30
	  1995-12-22T09:05:02 = 22/12/1995 09:05
	 -0010-09-15T04:44:23 = 15/09/-010 04:44

       Default

	  2008-02-05T18:30:30 = 5 Feabh 2008 18:30:30
	  1995-12-22T09:05:02 = 22 Noll 1995 09:05:02
	 -0010-09-15T04:44:23 = 15 MFomh -10 04:44:23

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 Mairt
	  1995-12-22T09:05:02 = 22 Aoine
	 -0010-09-15T04:44:23 = 15 Sath

       HHmm (HH:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 09:05
	 -0010-09-15T04:44:23 = 04:44

       HHmmss (HH:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 p.m.
	  1995-12-22T09:05:02 = 9:05 a.m.
	 -0010-09-15T04:44:23 = 4:44 a.m.

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 p.m.
	  1995-12-22T09:05:02 = 9:05:02 a.m.
	 -0010-09-15T04:44:23 = 4:44:23 a.m.

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (d/M)

	  2008-02-05T18:30:30 = 5/2
	  1995-12-22T09:05:02 = 22/12
	 -0010-09-15T04:44:23 = 15/9

       MEd (E, M-d)

	  2008-02-05T18:30:30 = Mairt, 2-5
	  1995-12-22T09:05:02 = Aoine, 12-22
	 -0010-09-15T04:44:23 = Sath, 9-15

       MMdd (dd/MM)

	  2008-02-05T18:30:30 = 05/02
	  1995-12-22T09:05:02 = 22/12
	 -0010-09-15T04:44:23 = 15/09

       MMM (LLL)

	  2008-02-05T18:30:30 = Feabh
	  1995-12-22T09:05:02 = Noll
	 -0010-09-15T04:44:23 = MFomh

       MMMd (MMM d)

	  2008-02-05T18:30:30 = Feabh 5
	  1995-12-22T09:05:02 = Noll 22
	 -0010-09-15T04:44:23 = MFomh 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = Mairt Feabh 5
	  1995-12-22T09:05:02 = Aoine Noll 22
	 -0010-09-15T04:44:23 = Sath MFomh 15

       MMMMd (d MMMM)

	  2008-02-05T18:30:30 = 5 Feabhra
	  1995-12-22T09:05:02 = 22 Nollaig
	 -0010-09-15T04:44:23 = 15 Mean Fomhair

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = Mairt Feabhra 5
	  1995-12-22T09:05:02 = Aoine Nollaig 22
	 -0010-09-15T04:44:23 = Sath Mean Fomhair 15

       mmss (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (y-M)

	  2008-02-05T18:30:30 = 2008-2
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -10-9

       yMEd (EEE, y-M-d)

	  2008-02-05T18:30:30 = Mairt, 2008-2-5
	  1995-12-22T09:05:02 = Aoine, 1995-12-22
	 -0010-09-15T04:44:23 = Sath, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 Feabh
	  1995-12-22T09:05:02 = 1995 Noll
	 -0010-09-15T04:44:23 = -10 MFomh

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = Mairt, 2008 Feabh 5
	  1995-12-22T09:05:02 = Aoine, 1995 Noll 22
	 -0010-09-15T04:44:23 = Sath, -10 MFomh 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 Feabhra
	  1995-12-22T09:05:02 = 1995 Nollaig
	 -0010-09-15T04:44:23 = -10 Mean Fomhair

       yQ (y Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -10 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 R1
	  1995-12-22T09:05:02 = 1995 R4
	 -0010-09-15T04:44:23 = -10 R3

       yyMM (MM/yy)

	  2008-02-05T18:30:30 = 02/08
	  1995-12-22T09:05:02 = 12/95
	 -0010-09-15T04:44:23 = 09/-10

       yyMMM (MMM yy)

	  2008-02-05T18:30:30 = Feabh 08
	  1995-12-22T09:05:02 = Noll 95
	 -0010-09-15T04:44:23 = MFomh -10

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

       yyyyMM (MM/yyyy)

	  2008-02-05T18:30:30 = 02/2008
	  1995-12-22T09:05:02 = 12/1995
	 -0010-09-15T04:44:23 = 09/-010

       yyyyMMMM (MMMM y)

	  2008-02-05T18:30:30 = Feabhra 2008
	  1995-12-22T09:05:02 = Nollaig 1995
	 -0010-09-15T04:44:23 = Mean Fomhair -10

   Miscellaneous
       Prefers 24 hour time?

       Yes

       Local first day of the week

       De Domhnaigh

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.10.1							    2010-03-19					      DateTime::Locale::ga_IE(3pm)