|
|
Sponsored Content
Top Forums
UNIX for Advanced & Expert Users
Sed to format data in a file
Post 302225084 by vidyadhar85 on Thursday 14th of August 2008 01:49:23 PM
08-14-2008
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi I have a file which contains data (list of data) and I want to put a number with bracket 1) 2) 3) etc at the beginning of every successive line
I can do it with SED and I can also do it using the nl route but am looking for a different method.
I'm guessing I would need some sort of loop... (3 Replies)
Discussion started by: Cactus Jack
3 Replies
2. UNIX for Dummies Questions & Answers
I have a file with follwing content
----------------------------------
SCHEDULE XXXXXXXXX#JOBCOUNT
ON EVERYDAY
AT 0000
PRIORITY 50
SCHEDULE XXXXXXXXX#ABCDEFGH
ON EVERYDAY
AT 0001
PRIORITY 29
SCHEDULE... (5 Replies)
Discussion started by: shreyas
5 Replies
3. UNIX for Dummies Questions & Answers
Hello Experts,
I have a timestamp(6) column in a .csv data file , format of the data is as below:-
ETCT,P,Elec, Inc.,abc,11/5/2010 4:16:09.000000 PM,Y,Y,Y
I want the timestamp column to be properly formatted like
11/05/2010 04:16:09.000000 PM
Currently the "0" is missing with... (3 Replies)
Discussion started by: mtlrsk
3 Replies
4. Shell Programming and Scripting
Hi,
I have 3 kind of files that contains date data needed to be masked. The file is like this:
File 1 (all contents in 1 line):
input:DTM+7:201103281411:203'LOC+175+SGSIN:139:6+TERMINATOR......'DTM+132:201103281413:203'LOC....
output:... (4 Replies)
Discussion started by: Alvin123
4 Replies
5. UNIX for Dummies Questions & Answers
Hi,
Am having a file. I checked that file format by the following command
file filename
Output is
filename: data
So the file is data format file
Am trying to view that file so i have used some commands like cat,more so on but it showing the contents like compressed form(full of Symbols). How... (4 Replies)
Discussion started by: Adhi
4 Replies
6. UNIX for Dummies Questions & Answers
hi all,
i am new to unix forum,i want do some large data format work. pls help me to format the file.
i have attched data file to be formated in that two set of line item is there . first set header & second set header to be come in to single header item same as like all the data also.
... (2 Replies)
Discussion started by: dhamu
2 Replies
7. UNIX for Advanced & Expert Users
Hello All,
We are receiving UTF-16 formatted file and when i vi the file in Linux OS i am seeing some weird characters, is this because in my .bashrc profile the language variable has been set to LC_ALL=en_US.UTF-8 and hence the reason i am not able to read the UTF-16 formatted file properly? or... (2 Replies)
Discussion started by: Ariean
2 Replies
8. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
9. Shell Programming and Scripting
I have to sort below output in text file in unix bash
20170308
DA,I,113
20170308
PM,I,123
20170308
DA,U,22
20170308
PM,U,123
20170309
DA,I,11
20170309
PM,I,23
20170309
DA,U,123
20170309
PM,U,233 (8 Replies)
Discussion started by: Adfire
8 Replies
10. UNIX for Beginners Questions & Answers
I m looking for help here!!!
Can we filter the below log data into CSV format ?
1 2 3 4 5 6 7 8
timestamp INFO <text > - Some text (1 Reply)
Discussion started by: MohSalNiz
1 Replies
LEARN ABOUT DEBIAN
datetime::locale::tn_za
DateTime::Locale::tn_ZA(3pm) User Contributed Perl Documentation DateTime::Locale::tn_ZA(3pm) NAME
DateTime::Locale::tn_ZA - DateTime locale package for "tn_ZA" SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'tn_ZA' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for Tswana South Africa. DATA
This locale inherits from the DateTime::Locale::tn locale. It contains the following data. Days Wide (format) Mosopulogo Labobedi Laboraro Labone Labotlhano Matlhatso Tshipi Abbreviated (format) Mos Bed Rar Ne Tla Mat Tsh Narrow (format) 2 3 4 5 6 7 1 Wide (stand-alone) Mosopulogo Labobedi Laboraro Labone Labotlhano Matlhatso Tshipi Abbreviated (stand-alone) Mos Bed Rar Ne Tla Mat Tsh Narrow (stand-alone) 2 3 4 5 6 7 1 Months Wide (format) Ferikgong Tlhakole Mopitlo Moranang Motsheganang Seetebosigo Phukwi Phatwe Lwetse Diphalane Ngwanatsele Sedimonthole Abbreviated (format) Fer Tlh Mop Mor Mot See Phu Pha Lwe Dip Ngw Sed Narrow (format) 1 2 3 4 5 6 7 8 9 10 11 12 Wide (stand-alone) Ferikgong Tlhakole Mopitlo Moranang Motsheganang Seetebosigo Phukwi Phatwe Lwetse Diphalane Ngwanatsele Sedimonthole Abbreviated (stand-alone) Fer Tlh Mop Mor Mot See Phu Pha Lwe Dip Ngw Sed Narrow (stand-alone) 1 2 3 4 5 6 7 8 9 10 11 12 Quarters Wide (format) Q1 Q2 Q3 Q4 Abbreviated (format) Q1 Q2 Q3 Q4 Narrow (format) 1 2 3 4 Wide (stand-alone) Q1 Q2 Q3 Q4 Abbreviated (stand-alone) Q1 Q2 Q3 Q4 Narrow (stand-alone) 1 2 3 4 Eras Wide BC AD Abbreviated BC AD Narrow BC AD Date Formats Full 2008-02-05T18:30:30 = Labobedi, 2008 Tlhakole 05 1995-12-22T09:05:02 = Labotlhano, 1995 Sedimonthole 22 -0010-09-15T04:44:23 = Matlhatso, -10 Lwetse 15 Long 2008-02-05T18:30:30 = 2008 Tlhakole 5 1995-12-22T09:05:02 = 1995 Sedimonthole 22 -0010-09-15T04:44:23 = -10 Lwetse 15 Medium 2008-02-05T18:30:30 = 2008 Tlh 5 1995-12-22T09:05:02 = 1995 Sed 22 -0010-09-15T04:44:23 = -10 Lwe 15 Short 2008-02-05T18:30:30 = 08/02/05 1995-12-22T09:05:02 = 95/12/22 -0010-09-15T04:44:23 = -10/09/15 Default 2008-02-05T18:30:30 = 2008 Tlh 5 1995-12-22T09:05:02 = 1995 Sed 22 -0010-09-15T04:44:23 = -10 Lwe 15 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 = Labobedi, 2008 Tlhakole 05 18:30:30 UTC 1995-12-22T09:05:02 = Labotlhano, 1995 Sedimonthole 22 09:05:02 UTC -0010-09-15T04:44:23 = Matlhatso, -10 Lwetse 15 04:44:23 UTC Long 2008-02-05T18:30:30 = 2008 Tlhakole 5 18:30:30 UTC 1995-12-22T09:05:02 = 1995 Sedimonthole 22 09:05:02 UTC -0010-09-15T04:44:23 = -10 Lwetse 15 04:44:23 UTC Medium 2008-02-05T18:30:30 = 2008 Tlh 5 18:30:30 1995-12-22T09:05:02 = 1995 Sed 22 09:05:02 -0010-09-15T04:44:23 = -10 Lwe 15 04:44:23 Short 2008-02-05T18:30:30 = 08/02/05 18:30 1995-12-22T09:05:02 = 95/12/22 09:05 -0010-09-15T04:44:23 = -10/09/15 04:44 Default 2008-02-05T18:30:30 = 2008 Tlh 5 18:30:30 1995-12-22T09:05:02 = 1995 Sed 22 09:05:02 -0010-09-15T04:44:23 = -10 Lwe 15 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 Bed 1995-12-22T09:05:02 = 22 Tla -0010-09-15T04:44:23 = 15 Mat 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 PM 1995-12-22T09:05:02 = 9:05 AM -0010-09-15T04:44:23 = 4:44 AM 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 PM 1995-12-22T09:05:02 = 9:05:02 AM -0010-09-15T04:44:23 = 4:44:23 AM 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 = Bed, 2-5 1995-12-22T09:05:02 = Tla, 12-22 -0010-09-15T04:44:23 = Mat, 9-15 MMM (LLL) 2008-02-05T18:30:30 = Tlh 1995-12-22T09:05:02 = Sed -0010-09-15T04:44:23 = Lwe MMMd (MMM d) 2008-02-05T18:30:30 = Tlh 5 1995-12-22T09:05:02 = Sed 22 -0010-09-15T04:44:23 = Lwe 15 MMMEd (E MMM d) 2008-02-05T18:30:30 = Bed Tlh 5 1995-12-22T09:05:02 = Tla Sed 22 -0010-09-15T04:44:23 = Mat Lwe 15 MMMMd (MMMM d) 2008-02-05T18:30:30 = Tlhakole 5 1995-12-22T09:05:02 = Sedimonthole 22 -0010-09-15T04:44:23 = Lwetse 15 MMMMEd (E MMMM d) 2008-02-05T18:30:30 = Bed Tlhakole 5 1995-12-22T09:05:02 = Tla Sedimonthole 22 -0010-09-15T04:44:23 = Mat Lwetse 15 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 = Bed, 2008-2-5 1995-12-22T09:05:02 = Tla, 1995-12-22 -0010-09-15T04:44:23 = Mat, -10-9-15 yMMM (y MMM) 2008-02-05T18:30:30 = 2008 Tlh 1995-12-22T09:05:02 = 1995 Sed -0010-09-15T04:44:23 = -10 Lwe yMMMEd (EEE, y MMM d) 2008-02-05T18:30:30 = Bed, 2008 Tlh 5 1995-12-22T09:05:02 = Tla, 1995 Sed 22 -0010-09-15T04:44:23 = Mat, -10 Lwe 15 yMMMM (y MMMM) 2008-02-05T18:30:30 = 2008 Tlhakole 1995-12-22T09:05:02 = 1995 Sedimonthole -0010-09-15T04:44:23 = -10 Lwetse 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 Q1 1995-12-22T09:05:02 = 1995 Q4 -0010-09-15T04:44:23 = -10 Q3 yyQ (Q yy) 2008-02-05T18:30:30 = 1 08 1995-12-22T09:05:02 = 4 95 -0010-09-15T04:44:23 = 3 -10 Miscellaneous Prefers 24 hour time? Yes Local first day of the week Mosopulogo 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::tn_ZA(3pm)