Deleting rows from a csv file with bat or shell

Question

Deleting rows from a csv file with bat or shell

Navigation

#1 by (0 votes)

0

I have a file with 150k lines, in these lines I contain information that goes to a label printer. But at the time of printing, the program checks the 150k lines to see if there is any duplicity, it greatly disrupts the printing process.

How can I create a .bat to delete most of these lines, decreasing the crawl time? I tried using power shell, but I could only delete and .txt files, .csv I can not.

$Arquivo="C:\Users\Cis da Amazonia\Desktop\LR21DataCombine.txt"


$Conteudo = Get-Content -path $Arquivo

#Retira as linhas por quatidade
$tmp = $Conteudo[2..($Conteudo.Length-1)]

#Grava Modificações
$tmp > $Arquivo

cmd powershell ms-dos

asked by anonymous 07.04.2017 / 23:03

1 answer

How to disable double click on the header of a DataGrid? Mail function () php, request data

score 0 · Answer 1

Here it worked normally just by pointing to the CSV file instead of the txt, what is wrong with you?

I did the Test as well

$Arquivo="C:\Users\Cis da Amazonia\Desktop\LR21DataCombine.csv"

$Conteudo = Get-Content -path $Arquivo

#Retira as linhas por quatidade
$tmp = $Conteudo[2..($Conteudo.Length-10000)]

#Grava Modificações
$tmp > $Arquivo