|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Getting data from a flat file based on condition
Post 302885875 by Corona688 on Tuesday 28th of January 2014 04:53:22 PM
01-28-2014
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have an urgent task here. I am required to sort a flat file based on multiple columns which are based on the character position in that line. I am restricted to use the character position instead of the space and sort +1 +2 etc to do the sorting.
I understand that there is a previous... (8 Replies)
Discussion started by: cucubird
8 Replies
2. Shell Programming and Scripting
Hi
I have the fixed width flat file having the following data
12345aaaaaaaaaabbbbbbbbbb
12365sssssssssscccccccccc
12365sssss
12367ddddddddddvvvvvvvvvv
12367 vvvvv
Here the first column is length 5 second is length 10 third is length 10
if the second or third column exceeds... (3 Replies)
Discussion started by: Brado
3 Replies
3. Shell Programming and Scripting
Hi All,
I am a newbee in unix but still have written a shell script which should trigger a mail based on certain conditions but the problem is that my file is not being read. Below is the code please advise. I do not know where is it failing.
Note $ and the no followed with it is the no of... (1 Reply)
Discussion started by: apoorva
1 Replies
4. Shell Programming and Scripting
I have a flat file with records like
Header
123 James Williams Finance2000
124 Pete Pete HR 1500
125 PatrickHeather Engg 3000
Footer
The structure is:
Eno:4 characters
Name:8 characters
Surname : 9 characters
Dept:7 characters
Sal:4characters
These are sample... (1 Reply)
Discussion started by: Shivdatta
1 Replies
5. UNIX for Dummies Questions & Answers
All,
Can anyone please help me with the below scenario.
I have a Flat file of the below format.
ID|Name|Level|Type|Zip|MAD|Risk|Band|Salesl|Dealer|CID|AType|CValue|LV|HV|DCode|TR|DU|NStartDate|UserRole|WFlag|EOption|PName|NActivationDate|Os|Orig|Cus|OType|ORequired|DType
03|... (10 Replies)
Discussion started by: sp999
10 Replies
6. Shell Programming and Scripting
I have a file something like this:aaaa.xml content of the file is
0,<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<storeInformation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<s>
<BRANCH_NO>3061</BRANCH_NO>
<BRANCH_NAME>GREEN EXPRESS</BRANCH_NAME> ... (4 Replies)
Discussion started by: kmanivan82
4 Replies
7. UNIX for Dummies Questions & Answers
hi
i have my input data like this
aaa bbb ccc
asa dff nmj
mnj saa dff
oik
aax cdx saa
oik
asq sdf dssi want my output file to be like this
mnj saa dff oik
aax cdx saa oiki want to retain only those lines which will have oik just below them and i want oik to be as next column to those... (1 Reply)
Discussion started by: anurupa777
1 Replies
8. Shell Programming and Scripting
Hello,
For example:
12........6789101112..............20212223242526..................50 ( Positions)
LName FName DOB (Lastname starts from 1 to 6 , FName from 8 to 15 and date of birth from 21 to29)
CURTIS KENNETH ... (5 Replies)
Discussion started by: duplicate
5 Replies
9. Shell Programming and Scripting
I have a file in which the data looks like
A,B
My output should be
T1.A=T2.A
AND T1.B=T2.B
If my input is
A,B,C
My output should be
T1.A=T2.A
AND T1.B=T2.B
AND T1.C=T2.C
Currently I am automating my databae script and strucked with this part.Not able to search the... (2 Replies)
Discussion started by: bikky6
2 Replies
10. Shell Programming and Scripting
I collect data in a file in below format(Month Day Year Size) in RedHat Linux. Now i want to calculate the data size date wise. As i code shell script after long time, i forgot the features and syntax. Can anyone help me regard this please.
Feb 8 2014 15
Feb 10 2014 32
Feb 10 2014 32
Feb 12... (2 Replies)
Discussion started by: makauser
2 Replies
LEARN ABOUT DEBIAN
datetime::locale::ms_bn
DateTime::Locale::ms_BN(3pm) User Contributed Perl Documentation DateTime::Locale::ms_BN(3pm) NAME
DateTime::Locale::ms_BN - DateTime locale package for "ms_BN" SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'ms_BN' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for Malay Brunei. DATA
This locale inherits from the DateTime::Locale::ms locale. It contains the following data. Days Wide (format) Isnin Selasa Rabu Khamis Jumaat Sabtu Ahad Abbreviated (format) Isn Sel Rab Kha Jum Sab Ahd Narrow (format) 2 3 4 5 6 7 1 Wide (stand-alone) Isnin Selasa Rabu Khamis Jumaat Sabtu Ahad Abbreviated (stand-alone) Isn Sel Rab Kha Jum Sab Ahd Narrow (stand-alone) 2 3 4 5 6 7 1 Months Wide (format) Januari Februari Mac April Mei Jun Julai Ogos September Oktober November Disember Abbreviated (format) Jan Feb Mac Apr Mei Jun Jul Ogos Sep Okt Nov Dis Narrow (format) 1 2 3 4 5 6 7 8 9 10 11 12 Wide (stand-alone) Januari Februari Mac April Mei Jun Julai Ogos September Oktober November Disember Abbreviated (stand-alone) Jan Feb Mac Apr Mei Jun Jul Ogos Sep Okt Nov Dis Narrow (stand-alone) 1 2 3 4 5 6 7 8 9 10 11 12 Quarters Wide (format) suku pertama suku kedua suku ketiga suku keempat Abbreviated (format) S1 S2 S3 S4 Narrow (format) 1 2 3 4 Wide (stand-alone) suku pertama suku kedua suku ketiga suku keempat Abbreviated (stand-alone) S1 S2 S3 S4 Narrow (stand-alone) 1 2 3 4 Eras Wide BCE CE Abbreviated S.M. T.M. Narrow S.M. T.M. Date Formats Full 2008-02-05T18:30:30 = 05 Februari 2008 1995-12-22T09:05:02 = 22 Disember 1995 -0010-09-15T04:44:23 = 15 September -10 Long 2008-02-05T18:30:30 = 05 Februari 2008 1995-12-22T09:05:02 = 22 Disember 1995 -0010-09-15T04:44:23 = 15 September -10 Medium 2008-02-05T18:30:30 = 05/02/2008 1995-12-22T09:05:02 = 22/12/1995 -0010-09-15T04:44:23 = 15/09/-010 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 = 05/02/2008 1995-12-22T09:05:02 = 22/12/1995 -0010-09-15T04:44:23 = 15/09/-010 Time Formats Full 2008-02-05T18:30:30 = 6:30:30 PM UTC 1995-12-22T09:05:02 = 9:05:02 AM UTC -0010-09-15T04:44:23 = 4:44:23 AM 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 = 05 Februari 2008 6:30:30 PM UTC 1995-12-22T09:05:02 = 22 Disember 1995 9:05:02 AM UTC -0010-09-15T04:44:23 = 15 September -10 4:44:23 AM UTC Long 2008-02-05T18:30:30 = 05 Februari 2008 18:30:30 UTC 1995-12-22T09:05:02 = 22 Disember 1995 9:05:02 UTC -0010-09-15T04:44:23 = 15 September -10 4:44:23 UTC Medium 2008-02-05T18:30:30 = 05/02/2008 18:30:30 1995-12-22T09:05:02 = 22/12/1995 9:05:02 -0010-09-15T04:44:23 = 15/09/-010 4:44:23 Short 2008-02-05T18:30:30 = 05/02/2008 18:30 1995-12-22T09:05:02 = 22/12/1995 9:05 -0010-09-15T04:44:23 = 15/09/-010 4:44 Default 2008-02-05T18:30:30 = 05/02/2008 18:30:30 1995-12-22T09:05:02 = 22/12/1995 9:05:02 -0010-09-15T04:44:23 = 15/09/-010 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 (d EEE) 2008-02-05T18:30:30 = 5 Sel 1995-12-22T09:05:02 = 22 Jum -0010-09-15T04:44:23 = 15 Sab 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 Hmm (H:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 9:05 -0010-09-15T04:44:23 = 4:44 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 = Sel, 2-5 1995-12-22T09:05:02 = Jum, 12-22 -0010-09-15T04:44:23 = Sab, 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 = Feb 1995-12-22T09:05:02 = Dis -0010-09-15T04:44:23 = Sep MMMd (MMM d) 2008-02-05T18:30:30 = Feb 5 1995-12-22T09:05:02 = Dis 22 -0010-09-15T04:44:23 = Sep 15 MMMEd (E MMM d) 2008-02-05T18:30:30 = Sel Feb 5 1995-12-22T09:05:02 = Jum Dis 22 -0010-09-15T04:44:23 = Sab Sep 15 MMMMd (MMMM d) 2008-02-05T18:30:30 = Februari 5 1995-12-22T09:05:02 = Disember 22 -0010-09-15T04:44:23 = September 15 MMMMdd (dd MMMM) 2008-02-05T18:30:30 = 05 Februari 1995-12-22T09:05:02 = 22 Disember -0010-09-15T04:44:23 = 15 September MMMMEd (E MMMM d) 2008-02-05T18:30:30 = Sel Februari 5 1995-12-22T09:05:02 = Jum Disember 22 -0010-09-15T04:44:23 = Sab September 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 = Sel, 2008-2-5 1995-12-22T09:05:02 = Jum, 1995-12-22 -0010-09-15T04:44:23 = Sab, -10-9-15 yMMM (y MMM) 2008-02-05T18:30:30 = 2008 Feb 1995-12-22T09:05:02 = 1995 Dis -0010-09-15T04:44:23 = -10 Sep yMMMEd (EEE, y MMM d) 2008-02-05T18:30:30 = Sel, 2008 Feb 5 1995-12-22T09:05:02 = Jum, 1995 Dis 22 -0010-09-15T04:44:23 = Sab, -10 Sep 15 yMMMM (y MMMM) 2008-02-05T18:30:30 = 2008 Februari 1995-12-22T09:05:02 = 1995 Disember -0010-09-15T04:44:23 = -10 September 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 S1 1995-12-22T09:05:02 = 1995 S4 -0010-09-15T04:44:23 = -10 S3 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 = Februari 2008 1995-12-22T09:05:02 = Disember 1995 -0010-09-15T04:44:23 = September -10 Miscellaneous Prefers 24 hour time? Yes Local first day of the week Isnin 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::ms_BN(3pm)