Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

URGENT: Read CSV file and altert details via formatted email (UNIX SHELL SCRIPT)

Avatar of Dushan De Silva
Dushan De SilvaFlag for Australia asked on
Unix OSEmail ClientsShell ScriptingMultimedia Programming
19 Comments1 Solution2542 ViewsLast Modified:
Hi Experts,
I'm having following csv file format and I want to read that file and should send email alters if last column values are difference
------------------csv file------------------
Query,group,IBM,product
Clam,Senehasa,12345,12345
Jane,SSC,23456,23457
Mmettha,SSC,34567,34566
--------------------------------------------
first line of this csv file contains titles of columns.
If there is any count difference between last two columns(IBM and product) then email alert should send to dushan_desilva@yahoo.com
mentioning that particular row with details and it should be in red color as attached image with additional delta field.

Also error handling(while reading csv file and sending emails) should write to a log file.

https://www.experts-exchange.com/OS/Unix/Q_26557443.html

BR Dushan.
delta.jpg
ASKER CERTIFIED SOLUTION
Avatar of dimaj
dimajFlag of United States of America image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 19 Comments.
See Answers