Win Server 2008: .bat to read and append/create new file files

[goodmans]

Hi,

Platform: Win Server 08

Requirement is
InputFile:
File1 Contents:
Row1: Col1_VALUE, Col2_Value, Col3_Value
Row2: Col1_VALUE, Col2_Value, Col3_Value
Row3: Col1_VALUE, Col2_Value, Col3_Value
Row4: Col1_VALUE, Col2_Value, Col3_Value

OutputFile: Loop No of rows in File1 (4)
(
Param1=<Col1_Value in Row1..4>
Param2=<Col2_Value in Row1..4>
Param3=<Col3_Value in Row1..4>
)

Script is to execute an exe file 4 times once for a row in Input file.

Please let me how i can achieve this. Will i be able to execute this using VBS? do i need to install any library to execute vbs. i am very new to this. I know how i can do this in Unix. using sed functionality. But dont know how to achieve this in windows. Please help.

Regards
Suresh

 

[Geates]

Is your goal to output the parameters to a file or use them to execute?

Here's the basic idea to split up the data

arrRows = array("1A, 2A, 3A", "1B, 2B, 3B", "1C, 2C, 3C")
for i = 0 to ubound(arr)
	arr(i) = split(arr(i), ",")
next

strParam = arr(1)(2)

-Geates

http://raqxtr.sstar.com/caspdoc/html/chapter_5__developer_s_reference.htm

 

[Geates]

oh, btw, this is a vbscript forum, not a batch forum. also, vbs is native to windows so there isn't anything you need to install.

-Geates

http://raqxtr.sstar.com/caspdoc/html/chapter_5__developer_s_reference.htm