[u0206397]

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

Example of CSV:

PHP Code: 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:

PHP Code: 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? )

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

PowerShell?

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

Python?

Code: 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

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

For perl, you can do this

Code: 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]

u0206397 wrote:

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.