AnsweredAssumed Answered

CSV collection ignoring the first line

Question asked by Jesvin Joseph on Jan 4, 2019
Latest reply on Jan 4, 2019 by Mostafa Helmy

Hi All,

 

We are trying to collect data from a csv file, which includes a hashed first line, which should be ignored during collection. Since the csv is getting generated directly from a powershell script, the first line cannot be removed. Is there a way to ignore the first line during collection.?

 

Below is the sample data ;

 

#TYPE Selected.Microsoft.Exchange.Data.Directory.Management.MailUser
"SamAccountName","PrimarySmtpAddress"
"John.Smith","John.Smith@xyz.com"

"Mike.S","Mike.S@xyz.com"

Outcomes