03-03-2007
Working with field increments
I have a new challenge that I need some help with. Each morning I have two files that contain working units and failed units that I join together to form file3 which is FTP to server for comparison against billing system.
My problem, I would like to take joined data in file3 and add a field that would increase the count by 1 for any unit found to be a failed unit. The count would continue until the failed unit is removed, which could be in excess of 365 days or next day. Both failed and working files change daily.
File1 working units change daily but average around 125,000 and file2 failed unit's average 25,000, totaling 150,000 records in file3. I will use cron to run script daily.
Sample file3 output current:
123xxx|123xxx|123xxx|123xxx|123xxx|current field|
123xxx|123xxx|123xxx|123xxx|123xxx|current field|
123xxx|123xxx|123xxx|123xxx|123xxx|current field|
New file3 output:
123xxx|123xxx|123xxx|123xxx|123xxx|current field|failed count days
123xxx|123xxx|123xxx|123xxx|123xxx|current field| 1
123xxx|123xxx|123xxx|123xxx|123xxx|current field| 2
123xxx|123xxx|123xxx|123xxx|123xxx|current field| 34
123xxx|123xxx|123xxx|123xxx|123xxx|current field| 57
123xxx|123xxx|123xxx|123xxx|123xxx|current field| 365
10 More Discussions You Might Find Interesting
1. Programming
Hi all,
Situation is as below.
I would get an IP address and port from eithe r a file or command line. It probably would be as char * or string. So was wondering how I could accept this and increment the last octets?
Incrementing the port is fine. I could get that into an integer by atoi()... (8 Replies)
Discussion started by: Naanu
8 Replies
2. UNIX for Dummies Questions & Answers
I have a file that varies in the # of records. I want to read 1000 records, do something, read the next 1000 records, do something, going in 1000 increment chunks, and then finish up with whatever is left over at end of file. (1 Reply)
Discussion started by: Tsamp
1 Replies
3. Shell Programming and Scripting
I want to sort alphabetically on the first field and sort in descending numerical order on the 2nd field. With a normal "sort -r -n" it does this:
abc ||| 5e-05 ||| bla
abc ||| 3 ||| ble
def ||| 1 ||| abc
def ||| 0.2 ||| def
As you can see it ignores the fact that 5e-05 is actually 0.00005... (1 Reply)
Discussion started by: FrancoisCN
1 Replies
4. Shell Programming and Scripting
Hi, I only have a very limited understanding and experience with writing code and I was hoping I could get some help.
I have a dataset of two columns (txt format, numbers in each row separated by a tab)
Eg.
1 5
2 5
3 6
4 7
5 6
6 6
7 ... (5 Replies)
Discussion started by: Emred_Skye
5 Replies
5. Shell Programming and Scripting
Hi All,
I am trying to implement a for loop in a .sh file and execute it.
My for loop is
for i in 1, 200, 400, 600, 800, 1000, 1200,......100000
do
...
..
..
done
As you could see there is an increment of 200 in each for loop until it reaches 100,000
Instead of specifying all the... (8 Replies)
Discussion started by: Lucky Ali
8 Replies
6. Shell Programming and Scripting
First, thanks for the help in previous posts... couldn't have gotten where I am now without it!
So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following:
If $1... (4 Replies)
Discussion started by: right_coaster
4 Replies
7. Shell Programming and Scripting
I have 2 fixed length files input#1 & input#2. I want to match the rows based on the value in position 37-50 in both files (pos 37-50 will have same value in both files).
If any matching record is found then cut the value against company code & Invoice number from input file #1 (position 99 until... (3 Replies)
Discussion started by: Lingaraju
3 Replies
8. Programming
no longer needed, please delete thread. (0 Replies)
Discussion started by: xtina
0 Replies
9. Shell Programming and Scripting
Table
ACN|NAME|CITY|CTY|NO1|NO2
115|AKKK|ASH|IND|10|15
115|AKKK|ASH|IND|20|20
115|AKKK|ASH|IND|30|35
115|AKKK|ASH|IND|30|35
112|ABC|FL|USA|15|15
112|ABC|FL|USA|25|20
112|ABC|FL|USA|25|45
i have written shell script using cut command
and awk programming getting error correct it and add... (5 Replies)
Discussion started by: udhal
5 Replies
10. UNIX for Beginners Questions & Answers
Hi, can some some help to get me the right results,
I have few text files, need to grep few columns from each file and get the results in one row with comma separated.
my code is
#folder=/nz/kit/log/backupsvr
folder=/export/home/nz/valai/tmpfiles/
echo $folder
for entry in `ls... (4 Replies)
Discussion started by: ValaiG
4 Replies
LEARN ABOUT SUNOS
ftpconfig
ftpconfig(1M) System Administration Commands ftpconfig(1M)
NAME
ftpconfig - set up anonymous FTP
SYNOPSIS
ftpconfig [ftpdir]
ftpconfig -d ftpdir
DESCRIPTION
The ftpconfig script is executed by the super user to set up anonymous FTP. Anonymous FTP allows users to remotely log on to the FTP server
by specifying the user name ftp or anonymous and the user's email address as password. The anonymous users are logged on to the FTP
Server and given access to a restricted file area with its own file system root. See chroot(2). The FTP area has its own minimal system
files.
This command will copy and set up all the components needed to operate an anonymous FTP server, including creating the ftp user account,
creating device nodes, copying /usr/lib files, and copying timezone data. The passwd and group files set up have been stripped down to
prevent malicious users from finding login names on the server. The anonymous file area will be placed under ftpdir. If the ftp user
account already exists, then the current FTP area is used, and the system files in it are updated. All other files are left untouched. This
command should be run to update the anonymous FTP area's configuration whenever a system patch is installed, or the system is upgraded.
OPTIONS
-d Create a new or update an existing ftpdir without creating or updating the ftp user account. Use this option when creating guest
FTP user accounts.
OPERANDS
The following operands are supported:
ftpdir The absolute pathname of the directory under which the anonymous FTP area is set up.
EXIT STATUS
The following exit values are returned:
0 Successful completion
1 Improper usage of the command
2 Command failed
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWftpu |
+-----------------------------+-----------------------------+
|Interface Stability |Evolving |
+-----------------------------+-----------------------------+
SEE ALSO
ftpaddhost(1M), in.ftpd(1M), useradd(1M), chroot(2), attributes(5)
SunOS 5.10 1 May 2003 ftpconfig(1M)