How to remove unwanted row?

[KalebeRS]

Hello,

I have this column named pverProduct. For some reason the header of the csv file got in the middle of the result. Is there a way to remove the unwanted row(pverProduct)?

index="" host= sourcetype=csv source=C:\\
| table pverProduct
| dedup pverProduct

[gcusello]

Hi @KalebeRS ,

please try:

index="" host= sourcetype=csv source=C:\\ pverProduct!="pverProduct"
| table pverProduct
| dedup pverProduct

Ciao.

Giuseppe

[jotne · Accepted solution]

Try add this as last line.  It will remove the line, but this is data that is already in your table.

| search pverProduct!="pverProduct"