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"
Looking at the HXTT driver website documentation (http://www.hxtt.com/text/faq.html) … this may be possible by adding an extra parameter _CSV_Comment to the collector URL.
15. How can we skip some header lines from a text file, say with some report header (My Project Budget)?
Text supports to skip some comment lines before csv header and data rows. If you use n (integer values), the first n lines will be ingored as comment. If you use some paragraphs, these paragraphs will be used for csv file creation, the total line number of comment will be used for existent file.
So in your case you can add _CSV_Comment=1; to your existing collector URL to skip the first line.
Looking at the HXTT driver website documentation (http://www.hxtt.com/text/faq.html) … this may be possible by adding an extra parameter _CSV_Comment to the collector URL.
15. How can we skip some header lines from a text file, say with some report header (My Project Budget)?
Text supports to skip some comment lines before csv header and data rows. If you use n (integer values), the first n lines will be ingored as comment. If you use some paragraphs, these paragraphs will be used for csv file creation, the total line number of comment will be used for existent file.
So in your case you can add _CSV_Comment=1; to your existing collector URL to skip the first line.