Hi Experts,
I need to extract AD Account name from an csv file that is in below format. In this csv file all the 3 lines has an “AD Account” name nidhinck. Whats the command i need to use to pull only the AD Account column from this csv file
3 Employee Terminations Approved and Processed by 2016-12-07
They are as follows:
"Employee #| Legacy ID| Cost Center| Job Title| Manager ID| Customer Dimention ID| Customer Dimention Description| AD Account| Last Name| First Name| Email Address| Hire Date| Term Date| Business Site| Termination Reason "
“123 |199 |800 PURCHASING [Local Cost Center] |Materials Analyst |6852 | | |nidhinck |ck |nidhin |nidhinck@outlook.com |2000-09-25 |2016-12-06 |US South Carolina Columbia |”
“124 |19505 |900 ENGINEERING OPERATIONS [Local Cost Center] |Test Technician |6852 | | |nidhinck |ck |nidhin |nidhinck@outlook.com |2000-09-25 |2016-12-06 |US South Carolina Columbia |”
“125 |19332 |100 ENGINEERING OPERATIONS [Local Cost Center] |Test Technician |6852 | | |nidhinck |ck |nidhin |nidhinck@outlook.com |2000-09-25 |2016-12-06 |US South Carolina Columbia |”