Scripting to run command line tools

[u0206397]

I have a CSV file containing data used to invoke a command line tool.

Example of CSV:

name,value
john,1
robert,2
michael,3
william,4
patricia,5
jennifer,6
linda,7
elizabeth,8

The command line would look like this:

process_data.exe -name "john" -value 1 -o "line_0001.dat"

... repeat ...

process_data.exe -name "elizabeth" -value 8 -o "line_0008.dat"

What is the easiest/elegant way to repeatedly execute a Windows command line program and vary the input parameters and output file name, hopefully without installing any complicated run time or interpreter environment?

Normal batch file (.bat and .cmd) can't seem to parse and loop a CSV file easily.

Perl? (interpolate the command line string with parameters and use backtick operator? )

`process_data.exe -name $name -value $value -o $outfile`

PowerShell?

Start-Process '$EXE -name "$name" -value "$VALUE" -o "$OUTFILE"'

Python?

os.system('process_data.exe -name "' + name + '" -value ' + value + ' -o "' + outfile + '"')

Not on Linux, so discounting Bash scripting.

 

[davidktw]

You can try activestate perl or gawk on windows

perl -ne '$a=split /,/;' < input.csv

For perl, you can do this

perl -ne '@a=split /,/; system("process_data", "-name", $a[0], "-value", "-o", sprintf("line_%04d.dat", $a[1])) unless ($a[0] != "name" and $a[1] != "value")'

 

[u0206397]

Giving ActivePerl a spin today.

I notice that the way PPM names their package is slightly different from CPAN. Using a hypen ( - ) instead of a double colon ( :: ). E.g. Data-Dumper (PPM) instead of Data:: Dumper (CPAN).

Not sure if this means any changes required in the code. Will try.

 

[davidktw]

Giving ActivePerl a spin today.

I notice that the way PPM names their package is slightly different from CPAN. Using a hypen ( - ) instead of a double colon ( :: ). E.g. Data-Dumper (PPM) instead of Data:: Dumper (CPAN).

Not sure if this means any changes required in the code. Will try.

That is the packaging name. The code still uses :: as the namespace separator.