|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
how to extract columns from a text file
Post 302191667 by learnbash on Sunday 4th of May 2008 06:36:15 AM
05-04-2008
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello!!
I have the text file with following format...
--SubTotal-----------------------------------0--161---------------44---13739369-67---
--SubTotal-----------------------------------0--147---------------0----49643---1----... (2 Replies)
Discussion started by: Danish Shakil
2 Replies
2. Shell Programming and Scripting
I have huge fixed width, text file in unix box and I need to extract columns found between the width 105 and 200 and output it to a new file.
Can anyone tell me how to extract it?
Thanks for your help. (1 Reply)
Discussion started by: kiran2k
1 Replies
3. Shell Programming and Scripting
Hi All,
Could you please help me with following:
I have to parse a .csv file.
For example: If the csv file contains 3 columns, then i have to print the column names. The field separator is (comma).
example.csv (contains 2 lines as follows)
This is,a test file, for validation... (2 Replies)
Discussion started by: vfrg
2 Replies
4. 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
5. 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
6. Shell Programming and Scripting
hello,
i have publicly available txt file with little less than 300000 rows. i want to extract from column 1 to column 218 and save it in another text file. i use the cut command but the file is saved with multiple rows from the source file onto a single row in the destination. basically it is... (6 Replies)
Discussion started by: madrazzii
6 Replies
7. Shell Programming and Scripting
Hello,
I want to concatenate 2-columns by 2-columns separated by colon. How can I do so? For example, I have a text file containing 6 columns separated by tab. I want to concatenate column 1 and 2; column 3 and 4; column 5 and 6, respectively, and put a colon in between.
input file:
1 0 0 1... (10 Replies)
Discussion started by: huiyee1
10 Replies
8. UNIX for Dummies Questions & Answers
Dear all,
I want to extract around 300 columns from a very large file with almost 2million columns. There are no headers, but I can find out which column numbers I want. I know I can extract with the function 'cut -f2' for example just the second column but how do I do this for such a large... (1 Reply)
Discussion started by: fndijk
1 Replies
9. Shell Programming and Scripting
I have a comma delimited file as per the one below and I am currently extracting the values in 2 columns (COL1 & COL6) to produce a smaller trimmed down version of the file which only contains the columns we need;
COL1,COL2,COL3,COL4,COL5,COL6,COL7,COL8,COL9... (1 Reply)
Discussion started by: Ads89
1 Replies
10. Shell Programming and Scripting
Kindly help merging information from two files with the following data structure.
I want to match for the CHR-SNP in Foo and get the columns that match from CHROM-rsID
Fields 1 & 2 of foo may have duplicates, however, a joint key of Fields $1$2$3$4 is unique.
Also would be helpful to clean up... (4 Replies)
Discussion started by: genehunter
4 Replies
LEARN ABOUT MOJAVE
datetime::locale::fa5.18
DateTime::Locale::fa(3) User Contributed Perl Documentation DateTime::Locale::fa(3) NAME
DateTime::Locale::fa SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'fa' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for Persian. DATA
This locale inherits from the DateTime::Locale::root locale. It contains the following data. Days Wide (format) XXXXXX XXXXXXX XXXXXXXX XXXXXXX XXXX XXXX XXXXXX Abbreviated (format) XXXXXX XXXXXXX XXXXXXXX XXXXXXX XXXX XXXX XXXXXX Narrow (format) X X X X X X X Wide (stand-alone) XXXXXX XXXXXXX XXXXXXXX XXXXXXX XXXX XXXX XXXXXX Abbreviated (stand-alone) 2 3 4 5 6 7 1 Narrow (stand-alone) X X X X X X X Months Wide (format) XXXXXXX XXXXXX XXXX XXXXX XXX XXXX XXXXXX XXX XXXXXXX XXXXX XXXXXX XXXXXX Abbreviated (format) XXXXXXX XXXXXX XXXX XXXXX XXX XXXX XXXXXX XXX XXXXXXX XXXXX XXXXXX XXXXXX Narrow (format) X X X X X X X X X X X X Wide (stand-alone) XXXXXX XXXXX XXXX XXXXX XX XXXX XXXXX XXX XXXXXXX XXXXX XXXXXX XXXXXX Abbreviated (stand-alone) XXXXXXX XXXXXX XXXX XXXXX XXX XXXX XXXXXX XXX XXXXXXX XXXXX XXXXXX XXXXXX Narrow (stand-alone) X X X X X X X X X X X X Quarters Wide (format) XXXXXXXX XXX XXXXXXXX XXX XXXXXXXX XXX XXXXXXXX XXXXX Abbreviated (format) XXXX XXXX XXXX XXXX Narrow (format) X X X X Wide (stand-alone) XXXXXXXX XXX XXXXXXXX XXX XXXXXXXX XXX XXXXXXXX XXXXX Abbreviated (stand-alone) XXXX XXXX XXXX XXXX Narrow (stand-alone) X X X X Eras Wide XXX XX XXXXX XXXXXX Abbreviated X.X. X. Narrow X X Date Formats Full 2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 2008 1995-12-22T09:05:02 = XXXX 22 XXXXXX 1995 -0010-09-15T04:44:23 = XXXX 15 XXXXXXX -10 Long 2008-02-05T18:30:30 = 5 XXXXXX 2008 1995-12-22T09:05:02 = 22 XXXXXX 1995 -0010-09-15T04:44:23 = 15 XXXXXXX -10 Medium 2008-02-05T18:30:30 = 2008/2/5 1995-12-22T09:05:02 = 1995/12/22 -0010-09-15T04:44:23 = -010/9/15 Short 2008-02-05T18:30:30 = 08/2/5 1995-12-22T09:05:02 = 95/12/22 -0010-09-15T04:44:23 = -10/9/15 Default 2008-02-05T18:30:30 = 5 XXXXXX 2008 1995-12-22T09:05:02 = 22 XXXXXX 1995 -0010-09-15T04:44:23 = 15 XXXXXXX -10 Time Formats Full 2008-02-05T18:30:30 = 18:30:30 (UTC) 1995-12-22T09:05:02 = 9:05:02 (UTC) -0010-09-15T04:44:23 = 4:44:23 (UTC) Long 2008-02-05T18:30:30 = 18:30:30 (UTC) 1995-12-22T09:05:02 = 9:05:02 (UTC) -0010-09-15T04:44:23 = 4:44:23 (UTC) Medium 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 9:05:02 -0010-09-15T04:44:23 = 4:44:23 Short 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 9:05 -0010-09-15T04:44:23 = 4:44 Default 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 9:05:02 -0010-09-15T04:44:23 = 4:44:23 Datetime Formats Full 2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 2008X XXXX 18:30:30 (UTC) 1995-12-22T09:05:02 = XXXX 22 XXXXXX 1995X XXXX 9:05:02 (UTC) -0010-09-15T04:44:23 = XXXX 15 XXXXXXX -10X XXXX 4:44:23 (UTC) Long 2008-02-05T18:30:30 = 5 XXXXXX 2008X XXXX 18:30:30 (UTC) 1995-12-22T09:05:02 = 22 XXXXXX 1995X XXXX 9:05:02 (UTC) -0010-09-15T04:44:23 = 15 XXXXXXX -10X XXXX 4:44:23 (UTC) Medium 2008-02-05T18:30:30 = 2008/2/5X XXXX 18:30:30 1995-12-22T09:05:02 = 1995/12/22X XXXX 9:05:02 -0010-09-15T04:44:23 = -010/9/15X XXXX 4:44:23 Short 2008-02-05T18:30:30 = 08/2/5X XXXX 18:30 1995-12-22T09:05:02 = 95/12/22X XXXX 9:05 -0010-09-15T04:44:23 = -10/9/15X XXXX 4:44 Default 2008-02-05T18:30:30 = 5 XXXXXX 2008X XXXX 18:30:30 1995-12-22T09:05:02 = 22 XXXXXX 1995X XXXX 9:05:02 -0010-09-15T04:44:23 = 15 XXXXXXX -10X XXXX 4: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 (EEE d) 2008-02-05T18:30:30 = XXXXXXX 5 1995-12-22T09:05:02 = XXXX 22 -0010-09-15T04:44:23 = XXXX 15 GGGGyyyyMMMMd (d MMMM y GGGG) 2008-02-05T18:30:30 = 5 XXXXXX 2008 XXXXXX 1995-12-22T09:05:02 = 22 XXXXXX 1995 XXXXXX -0010-09-15T04:44:23 = 15 XXXXXXX -10 XXX XX XXXXX HHmmZ (HH:mm (Z)) 2008-02-05T18:30:30 = 18:30 (+0000) 1995-12-22T09:05:02 = 09:05 (+0000) -0010-09-15T04:44:23 = 04:44 (+0000) 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 XXX XX XXX 1995-12-22T09:05:02 = 9:05 XXX XX XXX -0010-09-15T04:44:23 = 4:44 XXX XX XXX 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 XXX XX XXX 1995-12-22T09:05:02 = 9:05:02 XXX XX XXX -0010-09-15T04:44:23 = 4:44:23 XXX XX XXX M (L) 2008-02-05T18:30:30 = 2 1995-12-22T09:05:02 = 12 -0010-09-15T04:44:23 = 9 Md (M/d) 2008-02-05T18:30:30 = 2/5 1995-12-22T09:05:02 = 12/22 -0010-09-15T04:44:23 = 9/15 MEd (E M/d) 2008-02-05T18:30:30 = XXXXXXX 2/5 1995-12-22T09:05:02 = XXXX 12/22 -0010-09-15T04:44:23 = XXXX 9/15 MMM (LLL) 2008-02-05T18:30:30 = XXXXXX 1995-12-22T09:05:02 = XXXXXX -0010-09-15T04:44:23 = XXXXXXX MMMd (d LLL) 2008-02-05T18:30:30 = 5 XXXXXX 1995-12-22T09:05:02 = 22 XXXXXX -0010-09-15T04:44:23 = 15 XXXXXXX MMMEd (E d LLL) 2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 1995-12-22T09:05:02 = XXXX 22 XXXXXX -0010-09-15T04:44:23 = XXXX 15 XXXXXXX MMMMd (d LLLL) 2008-02-05T18:30:30 = 5 XXXXX 1995-12-22T09:05:02 = 22 XXXXXX -0010-09-15T04:44:23 = 15 XXXXXXX MMMMEd (E d LLLL) 2008-02-05T18:30:30 = XXXXXXX 5 XXXXX 1995-12-22T09:05:02 = XXXX 22 XXXXXX -0010-09-15T04:44:23 = XXXX 15 XXXXXXX 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 (yyyy/M) 2008-02-05T18:30:30 = 2008/2 1995-12-22T09:05:02 = 1995/12 -0010-09-15T04:44:23 = -010/9 yMEd (E yyyy/M/d) 2008-02-05T18:30:30 = XXXXXXX 2008/2/5 1995-12-22T09:05:02 = XXXX 1995/12/22 -0010-09-15T04:44:23 = XXXX -010/9/15 yMMM (MMM y) 2008-02-05T18:30:30 = XXXXXX 2008 1995-12-22T09:05:02 = XXXXXX 1995 -0010-09-15T04:44:23 = XXXXXXX -10 yMMMEd (E d MMM y) 2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 2008 1995-12-22T09:05:02 = XXXX 22 XXXXXX 1995 -0010-09-15T04:44:23 = XXXX 15 XXXXXXX -10 yMMMM (MMMM y) 2008-02-05T18:30:30 = XXXXXX 2008 1995-12-22T09:05:02 = XXXXXX 1995 -0010-09-15T04:44:23 = XXXXXXX -10 yQ (yyyy Q) 2008-02-05T18:30:30 = 2008 1 1995-12-22T09:05:02 = 1995 4 -0010-09-15T04:44:23 = -010 3 yQQQ (y QQQ) 2008-02-05T18:30:30 = 2008 XXXX 1995-12-22T09:05:02 = 1995 XXXX -0010-09-15T04:44:23 = -10 XXXX yyQ (Q yy) 2008-02-05T18:30:30 = 1 08 1995-12-22T09:05:02 = 4 95 -0010-09-15T04:44:23 = 3 -10 yyyyM (yyyy/M) 2008-02-05T18:30:30 = 2008/2 1995-12-22T09:05:02 = 1995/12 -0010-09-15T04:44:23 = -010/9 yyyyMMMM (MMMM y) 2008-02-05T18:30:30 = XXXXXX 2008 1995-12-22T09:05:02 = XXXXXX 1995 -0010-09-15T04:44:23 = XXXXXXX -10 yyyyMMMMEEEEd (EEEE d MMMM y) 2008-02-05T18:30:30 = XXXXXXX 5 XXXXXX 2008 1995-12-22T09:05:02 = XXXX 22 XXXXXX 1995 -0010-09-15T04:44:23 = XXXX 15 XXXXXXX -10 Miscellaneous Prefers 24 hour time? Yes Local first day of the week XXXXXX 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.18.2 2017-10-06 DateTime::Locale::fa(3)