awk '
match($0, /"username":"[^"]*"/) {
split($3, d, "@")
user = substr($0, RSTART + 12, RLENGTH - 17)
split(user, e, "@")
c[e[2] "," d[1] "," e[1]]++
}
END { for(i in c)
printf("%d,%s\n", c[i], i)
}' liquidgrids.log | sort -t, -k2,2 -k3,3 -k4,4
This works, now I just need to get the first column in the output (which is the number assigned to the total number of entries per user), to become the fourth column in the output.
I don't see anything in the above script that gets rid of the .com. And, I don't think I understand what:
you're trying to count,
the order of the output fields, nor
the desired output sort order (I think the sort keys are org, date, and user; but I'm not sure).
I assume that the even though joe@mycompany.com and joe@yourcompany.org both have user joe, you don't really want counts for joe do you? What about joe@abc.com, joe@abc.net, and joe@abc.org? Do you really believe that abc.com, abc.net, and abc.org are all addresses for the abc organization, or could these be three different organizations? Does your CEO really want to strip off the .com, .net, and .AnyOtherThing; or was that another knee jerk reaction without thinking about the consequences?
If you could give us about a 10 line sample log file and show us the exact output that your CEO wants from that sample, we might be willing to make one more attempt at a working solution.
I am writing a script that will identify the oldest file in a directory. Here's the syntax:
#!/bin/ksh
cd directory
chmod 777 *
ls -r -1t > file1
sed -n -e "1P" < file1 > file2
So my problem is, now I have file2, which contains the name of the oldest file in the directory. How do I use,... (1 Reply)
This script searches for core files and if it finds one, it emails me to let me know.I DONT want it to email me if it doesn't find one but I can't figure out what I need to change or add. Any thoughts? Script below:
/bin/find / -name core -type f -ls -exec file {} \;|/usr/bin/mailx -s... (1 Reply)
Hello
I am working on cleaning up permissions on Oracle mountpoints and datafiles in unix. I am looking for a script or a scripting idea to 1st.
1. grep for owner oracle
2. ensure its a directory owned for oracle
3. chmod 750 on the oracle owned directory.
4. grep for oracle files, etc... (3 Replies)
I'm new to shell scripting and am having a problem trying to do something in C shell. I want to write a script that will input something instead of a user doing it. For example, using the command 'write' the user is supposed to type something to be sent to another user. I want a script to be able... (3 Replies)
I am writing a backup script for AIX 5 and running into a problem where the output isn't being shown in the output log that is being created. Any ideas on how this would be corrected? I have included the script below. The only thing showing up in the file is listed below. I was hoping to capture... (2 Replies)
I'm writing a small script that will run an executable program (sort of like TOP). To exit the executable, you have to enter control C (^c). I'm trying to use a redirect input file to send the ^c but I'm not having any luck. My short script looks like this - /mydirectory/abc.script < abc.in >... (1 Reply)
Folks;
I'm writing a shell script to extract some fields out of a log file & it will run periodically, how can i make it runs starting from where it left of. for example;
if the script will do the extract every 2 days, let's say the first run will extract fields until July 25, 2007 @ 11:15:22... (1 Reply)
folks;
I have a script to remove any files that older than 14 days then move any files that younger than 7 days to another directory. but for some reason it doesn't move the files, when i do it manually it works but not through the script. i tried 2 different ways in writing the move part but it... (6 Replies)
Preview of command prompt
f ---> to start ferret
q----> to stop ferret
asp@nex:~$ f
NOAA/PMEL TMAP
FERRET v6.82
Linux 2.6.18-308.8.2.el5PAE 32-bit - 08/03/12
3-Dec-12 16:44
yes? go my.jnl
yes?column=4/skip=1/type=num,text ............filename.txt
---... (4 Replies)
hi all,
I am writing a script and beginner in shell scripting. I have tried the below script. could you please check and let me know whether the below scirpt is correct.
Unix details : HP Unix
Input file.
cat input.txt | tail -4
HTS40002.W1978.PROM
HTS40003.W1978.PROM... (17 Replies)
05-29-2015
