Jigna N. | 17+ IT Prof. Expr + Expertise in DWH | ETL | RPA | UNIX | DB of TECH + Consultant + Management + Leadership + Migration + Interviewer + Research + Philosophy Expr ( Jaisa Kaam, Waisa Daam !!! )
Thursday, March 23, 2023
Tuesday, June 7, 2022
Search on Particular Field even duplicate and print entire
Request detail
file1 has ids, needs to be mapped with file2 column 6, which has those ids and print in file 3
file 1 has duplicate ids and I want file3 to have file 2 column data printed with the duplicate ids.
eg:
file1:
1
2
2
4
file2:
a b c d e 2 f
a1 b1 c1 d1 e1 1 f1
a2 b2 c2 d2 e2 4 f2
file3 output:
a1 b1 c1 d1 e1 1 f1
a b c d e 2 f
a b c d e 2 f
a2 b2 c2 d2 e2 4 f2
After Executing Shell Script:
Unzip all files on target path with provision
Requirement:
Create a unzip all files in a directory using a shell script.
Additionally, every time a new zip file is added to the directory, the script to unzip only that new file, not the others that had been unzipped in the past.
Eg: Directory:
/mnt/something/P0045
Files in directory:
0045MYWORLD05152021.ZIP.TS05122021_TS23454.ZIP
0045MYWORLD06152021.ZIP.TS06122021_TS46201.ZIP
0045MYWORLD07152021.ZIP.TS07122021_TS12356.ZIP
First Unzip All:
| Input |
![]() |
| Output |
![]() |
| Input |
![]() |
| Output |
Thursday, June 2, 2022
Top 10 ip address access with how many time and last time access in Unix.
Requirement:
Top 10 ip address access with how many time and last time access.
Which can parse an Apache access log file and it can extract the top 10 domain name or IP address which have accessed any page of the web site; how many times the domain or the IP address has accessed any page of the web site and the last time of access of the web site. The date should be printed as YEAR-MONTH-DAY.
Input: access.log which contain 3485 records.
![]() |
| access.log |
Result:
![]() |
| Output |





.png)



