10-07-2016
Quote:
Originally Posted by
Don Cragun
In addition to what Chubler_XL has already said, if the dates to be used are based on the values in field #14 instead of being the dates on the 1st and last records in the file, you have to know the format of the date fields to determine how to perform the comparisons. And, if the values are to be extracted from the 1st and last data records in the file, we have to know if there are any header and/or trailer lines in the file.
This is why it is crucial that you give us a representative sample of the file(s) you will be processing.
Furthermore, you aren't at all clear about what tools are available for this project. You say the files you want to process are on a server. Will your script be run on that server while you are logged into that server? Will the files be located on one server while the script will be running on a different server?
The more details you hide from us, the less help we will be able to provide.
---------- Post updated at 09:15 AM ---------- Previous update was at 09:14 AM ----------
Chubler and don,
Thanks so much for your reply. I'll upload a sample file today. Thanks a million.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Greetings.
I am struggling with a shell script to make my life simpler, with a number of practical ways in which it could be used. I want to take a standard text file, and pull the 'n'th word from each line such as the first word from a text file.
I'm struggling to see how each line can be... (5 Replies)
Discussion started by: tricky
5 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I am writing a shell script to pull a file from a remote server (Let say its a windows based remote server). One of my criteria is to pull a file only if it is not empty.
We have done a similar script to push a file from our end to a remote server and before pushing it we check for the... (2 Replies)
Discussion started by: sashankkrk
2 Replies
3. Shell Programming and Scripting
Hi, I need help writing a script that would pull info from an email inbox and add it to an Evolution Calendar. I'm pretty sure I can google the commands to add the info to the calendar. The part that I really need help with is getting the info from the email into the command. Basically for... (6 Replies)
Discussion started by: xinix
6 Replies
4. Shell Programming and Scripting
Files xxxxxxx.txt
------------------------------------------------------------------------------------------------------------------------------------
Req.By: xxxxxxx WABUSH MINES -
xxxxxx MINE (1001) Page: 1
Run on: 12/14/09... (4 Replies)
Discussion started by: sctxms
4 Replies
5. Shell Programming and Scripting
I am hoping to get some help with a script to pull certain fields from a log file.
User update (xx6xxx P) rpt (yy6yyy B) 2010/01/20 21:36:01.298
Remote client forward start streamid 85af 2010/01/20 21:36:01.307
rpt2 (ZZ6ZZZ G) rpt1 (YY6YYY B) urcall (CQCQCQ ) mycall (W1AW)
user... (5 Replies)
Discussion started by: TedSD
5 Replies
6. Shell Programming and Scripting
Hi,
I have not used Unix in a very long time and I am very rusty. I would appreciate any help I can get from the more experienced and experts in Shell script.
I am reading one file at a time from a folder. The file is a flat file with no delimeters or carriage return. Col1 through col6 is... (5 Replies)
Discussion started by: asemota
5 Replies
7. Shell Programming and Scripting
I am attempting to write a script that will pull out NTLM hashes from a text file that contains about 500,000 lines of data. Not all accounts contain hashes and I only need the ones that do contain hashes.
Here is a sample of what the data looks like:
There are thousands of other lines in... (6 Replies)
Discussion started by: chango77747
6 Replies
8. Shell Programming and Scripting
Hello Gurus !
I have what probably amounts to a few simply changes to fix; however for the life of me I cannot seem to get it ti work. I need to align the output of my script (I am writing to a logfile)... here's the lines in my code:
if
then
echo "NODE: $node" >> $logfile... (6 Replies)
Discussion started by: gvolpini
6 Replies
9. Shell Programming and Scripting
I have a flat file A.txt with field seperate by a pipe
2012/11/13 20:06:11 | 284:hawk pid=014268 opened Locations 12, 13, 14, 15 for /home/hawk_t112/t112/macteam/qt/NET12/full_ddr3_2X_FV_4BD_1.qt/dbFiles/t112.proto|2012/11/14 15:19:26 | still running |norway|norway
2012/11/14 12:53:51 | ... (6 Replies)
Discussion started by: sabercats
6 Replies
10. Shell Programming and Scripting
Hi,
I want to know if there is any simple approach to SUM a field based on group by of different fields
for e.g.
file1.txt contains below data
20160622|XXX1||50.00||50.00|MONEY|Plan1|
20160622|XXX1||100.00||100.00|MONEY|Plan1|
20160623|XXX1||25.00||25.00|MONEY|Plan1|... (3 Replies)
Discussion started by: cnu_theprince
3 Replies
LEARN ABOUT SUSE
nwuserlist
NWUSERLIST(1) nwuserlist NWUSERLIST(1)
NAME
nwuserlist - List Users logged in at a NetWare server
SYNOPSIS
nwuserlist [ -h ] [ -S server ] [ -U user name ] [ -P password | -n ] [ -C ] [ -a ] [ -q ] [ -f [ -d ] [ -D ] [ -t ]]
DESCRIPTION
nwuserlist lists the users logged in at a NetWare server, together with their connection number and their login time.
nwuserlist looks up the file $HOME/.nwclient to find a file server, a user name and possibly a password. See nwclient(5) for more informa-
tion. Please note that the access permissions of $HOME/.nwclient MUST be 600 for security reasons.
OPTIONS
-h
-h is used to print out a short help text.
-S server
server is the name of the server you want to use.
-U user
user is the user name to use for login.
-P password
password is the password to use for login. If neither -n nor -P are given, and the user has no open connection to the server, nwuserlist
prompts for a password.
-n
-n should be given if no password is required for the login.
-C
By default, passwords are converted to uppercase before they are sent to the server, because most servers require this. You can turn off
this conversion by -C.
-a
With option -a the IPX address of the station the user is logged in from is printed as well.
-q
With option -q object ID is printed in addition to user name.
-f
List also files opened by each connection.
-d
List detailed informations about each file.
-D
List DOS filename instead of filename which was used for opening.
-t
Show raw hexadecimal values in addition to human readable conversions.
AUTHORS
nwuserlist was written by Volker Lendecke. See the Changes file of ncpfs for other contributors.
nwuserlist 7/22/1996 NWUSERLIST(1)