|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to concatenate 2-columns by 2 -columns for a text file?
Post 302891336 by huiyee1 on Wednesday 5th of March 2014 08:09:55 AM
03-05-2014
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello Gurus,
I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem?
The input file example,
... (6 Replies)
Discussion started by: Unilearn
6 Replies
2. Shell Programming and Scripting
i have a file which may have 'n' number of columns
1 222 fafda 32 afdaf 4343 4343
234 43fdaf 4343 fdd fdfd fdfd fdd fdfd fdfd
fdfd fdfd fdfd fdd fdfd fdfd
need to concatenate the columns with... (3 Replies)
Discussion started by: mlpathir
3 Replies
3. Shell Programming and Scripting
Hi,
I have a file1.txt like this:
and a file2.txt like this:
I wat only append file2.txt to file1.txt
and to have something like this:
How could i do ? (2 Replies)
Discussion started by: AdminLew
2 Replies
4. UNIX for Dummies Questions & Answers
I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns:
4 0.04972604 KLHL28
4 0.0497332 CSTB
4 0.04979822 AIF1
4 0.04983331 DECR2
4 0.04990344 KATNB1
4
4
4
4
How can I remove the trailing... (3 Replies)
Discussion started by: evelibertine
3 Replies
5. Shell Programming and Scripting
Hi all,
I want the 2nd column of every file in the directory in a single file with the file name as column header.
$cat file1.txt
a b c
d e f
$cat file2.txt
f g h
g h j
$cat file3.txt
a b d
f g h (2 Replies)
Discussion started by: newbie83
2 Replies
6. UNIX for Advanced & Expert Users
Hi All,
i have a .Csv file in the below format
startTime, endTime, delta, gName, rName, rNumber, m2239max, m2239min, m2239avg, m100016509avg, m100019240max, metric3min, m100019240avg, propValues
11-Mar-2012 00:00:00, 11-Mar-2012 00:05:00, 300.0, vma3550a, a-1_CPU Index<1>, 200237463, 0.0,... (9 Replies)
Discussion started by: mahi_mayu069
9 Replies
7. UNIX for Dummies Questions & Answers
hi all
could you please help me to concatenate two colomns and separate them by "-"
the two colomns to concatenate are colomuns 1 and 3 of a very bif file
clomn 1 is chr, 2 is snp and 3 is bp
the new colomn is chr_B
input file :
1 rs1111 10583
1 rs1891 10611
1 rs1807 ... (13 Replies)
Discussion started by: biopsy
13 Replies
8. Shell Programming and Scripting
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies
9. Shell Programming and Scripting
I have a CSV file that goes like this:
Name,Group,Email
Max,Group1,max@.com
Dan,Group2,dan@.com
Max,Group3,max@.com
Max,Group4,max@.com
Dan,Group5,dan@.com
Jim,Group6,jim@.comBasically my desired output should be:
Name,Group,Email
Max,Group1|Group3|Group4,max@.com... (6 Replies)
Discussion started by: jeffreybsu
6 Replies
10. Shell Programming and Scripting
Hi
i am having one requirement like to concatenate two columns in to one columns, can any one help on this please sample scenario i am placing below
COL1,COL2,COL3,COL4
1,A,B,C,D
2,e,f,g,h
ouput should be 3 columns like below.
COL1,COL2,newcolumns
1,A,B,CD
2,e,f,gh
... (9 Replies)
Discussion started by: bhaskar v
9 Replies
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)