10-11-2007
Extract column data from File
I have a file containing the lines similar to the following entries:
File1.txt:
.....
-rw-r--r-- 1 root staff 4110 Aug 7 17:02 XXX_OrderNum1_date1_time1.txt
-rw-r--r-- 1 root staff 4110 Aug 7 17:02 XXX_OrderNum2_date2_time1.txt
-rw-r--r-- 1 root staff 4110 Aug 7 17:02 XXX_OrderNum1_date2_time1.txt
....
My goal is to prepare a file which contains all the orders that occured more than once.
Like File2.txt:
OrderNum1 = 2 times
How can we achieve this?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
Consider the below column, say this is the 4th column in a file
PROV_STATS:::919900546978::Nokia 6600
PROV_STATS:::919900546978::Nokia 6600
PROV_STATS:::919900546978::Nokia 6600
I wanted to extract only 919900546978 from the 4 th cloumn using unix scripting?
Kindly help (8 Replies)
Discussion started by: Balaji Sukumara
8 Replies
2. Shell Programming and Scripting
My input file:
data_5 Ali 422 2.00E-45 102/253 140/253 24
data_3 Abu 202 60.00E-45 12/23 140/23 28
data_1 Ahmad 256 7.00E-45 120/235 140/235 22
data_4 Aman 365 8.00E-45 15/65 140/65 20
data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies
3. UNIX for Dummies Questions & Answers
Hi Unix Gurus,
I am newbie to UNIX. I have a file test.txt with the follwing data
aa90558
bb72962
cc08342
xy112233
yz25341
aa372099
cc34590231
bb880011
testfil
Whatisit00
1234556
testfile2test
I want to output only the items with two alpha followed by 5 numeric (ex aa90558 or... (2 Replies)
Discussion started by: SalM
2 Replies
4. Shell Programming and Scripting
Hi ,
I need to extract data from below mentioned data, having no delimiter and havin no fixed column length.
For example:
Member nbr Ref no date
10000 1000 10202012
200000 2000 11202012
Output:
to update DB with memeber nbr on basis of ref no.
... (6 Replies)
Discussion started by: ns64110
6 Replies
5. Shell Programming and Scripting
Can anyone please help with this? I have 2 files as given below.
If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value.
file1
abc_1 foo1@a ....
abc_1 soo2@a ...
def_2 soo2@a ....
def_2 foo1@a ........ (7 Replies)
Discussion started by: prashali
7 Replies
6. Shell Programming and Scripting
Hi,
I have a data file with :
01/28/2012,1,1,98995
01/28/2012,1,2,7195
01/29/2012,1,1,98995
01/29/2012,1,2,7195
01/30/2012,1,1,98896
01/30/2012,1,2,7083
01/31/2012,1,1,98896
01/31/2012,1,2,7083
02/01/2012,1,1,98896
02/01/2012,1,2,7083
02/02/2012,1,1,98899
02/02/2012,1,2,7083
I... (1 Reply)
Discussion started by: himanish
1 Replies
7. Shell Programming and Scripting
Hi, Great minds, I have some files, in fact header files, of CTD profiler, I tried a lot C programming, could not get output as I was expected, because my programming skills are very poor, finally, joined unix forum with the hope that, I may get what I want, from you people,
Here I have attached... (17 Replies)
Discussion started by: nex_asp
17 Replies
8. UNIX for Dummies Questions & Answers
I have a file which extracts data from an HTML file
For Eg HTML file contains:
New York;ABC;145;Yes;YES;No
New York;BCD;113;Yes;YES;No
New York;NAS;63;Yes;YES;No
------------------------
London-48;CBT;16;Yes;YES;No
London-48;CME;17;Yes;YES;No
London-48;EUR;52;Yes;YES;No... (3 Replies)
Discussion started by: newkid.7955
3 Replies
9. Shell Programming and Scripting
Hello,
I have this file outputData:
# cat /tmp/outputData
__Capacity^6^NBSC01_Licences^L3_functionality_for_ESB_switch
__Capacity^2100^NBSC01_Licences^Gb_over_IP
__Capacity^1837^NBSC01_Licences^EDGE_BSS_Fnc
__Capacity^1816^NBSC01_Licences^GPRS_CS3_and_CS4... (1 Reply)
Discussion started by: nypreH
1 Replies
10. UNIX for Beginners Questions & Answers
Source Code of the original script is down below please run the script and try to solve this problem
this is my data and I want it column wise
2019-03-20 13:00:00:000
2019-03-20 15:00:00:000
1
Operating System
LAB
0
1
1
1
1
1
1
1
1
1
0
1 (5 Replies)
Discussion started by: Shubham1182
5 Replies
LEARN ABOUT PLAN9
dh_usrlocal
DH_USRLOCAL(1) Debhelper DH_USRLOCAL(1)
NAME
dh_usrlocal - migrate usr/local directories to maintainer scripts
SYNOPSIS
dh_usrlocal [debhelperoptions] [-n]
DESCRIPTION
dh_usrlocal is a debhelper program that can be used for building packages that will provide a subdirectory in /usr/local when installed.
It finds subdirectories of usr/local in the package build directory, and removes them, replacing them with maintainer script snippets
(unless -n is used) to create the directories at install time, and remove them when the package is removed, in a manner compliant with
Debian policy. These snippets are inserted into the maintainer scripts by dh_installdeb. See dh_installdeb(1) for an explanation of
debhelper maintainer script snippets.
When the Rules-Requires-Root field is not (effectively) binary-targets, the directories in /usr/local will have ownership root:staff and
the mode will be 02775. These values have been chosen to comply with the recommendations of the Debian policy for directories in
/usr/local.
When Rules-Requires-Root has an effective value of binary-targets, the owners, groups and permissions will be preserved with one exception.
If the directory is owned by root:root, then ownership will be reset to root:staff and mode will be reset to 02775. This is useful, since
that is the group and mode policy recommends for directories in /usr/local.
OPTIONS
-n, --no-scripts
Do not modify postinst/prerm scripts.
NOTES
Note that this command is not idempotent. dh_prep(1) should be called between invocations of this command. Otherwise, it may cause multiple
instances of the same text to be added to maintainer scripts.
CONFORMS TO
Debian policy, version 2.2
SEE ALSO
debhelper(7)
This program is a part of debhelper.
AUTHOR
Andrew Stribblehill <ads@debian.org>
11.1.6ubuntu2 2018-05-10 DH_USRLOCAL(1)