0
votes
1answer
33 views

Batch file to search for and delete lines containing specifc text in a csv

I have a bat file that searches a directory for specific .csv files names, and copies and amends the lines into a new .csv file. However, some of the lines of the original .csv files are not ...
0
votes
0answers
24 views

Batch Script related issue

I have written following script which works absolutely fine on my system. @echo off setlocal enabledelayedexpansion FOR /F %%i IN ('wmic /node:%1 computersystem get Name') DO SET A=%%i FOR /F %%i ...
0
votes
3answers
38 views

How to read values in a particular column of a CSV file in Batch?

I am planning to write a batch script wherein I need to scan the values from a particular column of a CSV file one by one and store them in a variable for further processing. Say, following is the ...
0
votes
2answers
49 views

Creating Comma Separated Values in Batch Scripting

I have written a piece of code in Batch script which is somewhat like : ( wmic.exe /node:x.x.x.x computersystem get name wmic.exe /node:x.x.x.x computersystem get domain wmic.exe ...
0
votes
3answers
404 views

Search .csv from within a batch file

I am looking to create a batch file that will search a .csv for a specific number, and then use the 2nd value in the csv as the input back into the batch file. Example: csv name= IP.csv .csv ...
-3
votes
1answer
218 views

Deleting the first column of csv via batch commands [duplicate]

Is there a way to delete the first column of a csv using a batch command file? I have data in this first column but I want to get rid of it and output a new file starting at the 2nd column. Thanks!
0
votes
2answers
742 views

How a batch file overwrite contents of output each time?

Basically I have this batch file below, which will return the first x rows from the input .csv file parameter. However, the only issue now is that this batch file will be called several times to ...
1
vote
1answer
417 views

Adding Multiple users from .CSV via batch file

I wrote the following in a batch file start cmd.exe /k net user test1 1qaz2wsx!QAZ@WSX /add /y But I have to add a large number of users and passwords. I have them all in an excel file, is there ...
1
vote
4answers
3k views

Can I use a batch file to remove blank columns in a .csv

I have nine columns in my current .csv file, however, the 2nd and 3rd columns are blank and I want to get rid of them. Is there a way to use batch commands to remove these empty columns from my .csv ...
0
votes
1answer
425 views

Export the first three rows of a .csv into another .csv using batch commands

I have a .csv file with a number of rows but I only want the first three rows and none of the rest. How can I use a batch file to export those top 3 rows of my .csv file into another file .csv file? I ...
0
votes
3answers
900 views

Batch script to append record to csv files

I have a bunch of stock data in csv's that I am backtesting trading strategies on. The problem is that my strategy buys the open market price if a signal was found yesterday, unfortunately my data is ...
1
vote
2answers
510 views

Filter a CSV file using Windows batch file

I have a file with 12 columns separated by ? I need to export column number 12 (NetBIOS Name) and append the whole row to a CSV file. Skip the first line that is the column description. The first 4 ...
0
votes
1answer
722 views

how to filter CSV files using batch

How to filter CSV files using batch as below: I have a file with 7 columns separated by '~' I need to check if column number 4 is in (456,987,654,123,456), If yes than append the whole row to ...