"mail merge"-ish behavior?

Quadko · Nov 01, 2006#12006-11-01T00:01+00:00

I've got a template file and CSV file of values. I need to generate a set of files that fill the data into the template.

Is this something I can do using UE, or do you have any other tool recommendations? It's essentially a "mail merge" to generate .cmd script files...

Thanks!

Bego · Nov 01, 2006#22006-11-01T00:54+00:00

Give me an example please!

Quadko · Nov 01, 2006#32006-11-01T02:03+00:00

I have a CSV file:

Code: Select all

12, "RunEngine1.exe test1.xml >> output.txt"
15, "RunEngine3.exe MyInput.xml /opt >> output.txt"

I have a template file:

Code: Select all

SetupTest.exe /name=%1
%2
Record %1
cleanup.exe

From the above, I want 2 output files "test12.cmd" and "test15.t" that look like:

Code: Select all

SetupTest.exe /name=12
RunEngine1.exe test1.xml >> output.txt
Record 12
cleanup.exe

I have 500+ of these I want to generate

Bego · Nov 01, 2006#42006-11-01T02:36+00:00

hi Quadko,

well, this is NO problem at all. Only a time problem of me

Its late in Germany (and I have kids) and I got no more time, BUT I made a macro YOU can enhance easily.
I just saved the first line to test12.cmd.
Just enhance the macro yourself by following my "starter".macro.
Adopt the 2nd line also and put this stuff in a loop and you're done.

Code: Select all

InsertMode
ColumnModeOff
HexOff
PerlReOn
Top
Clipboard 1
StartSelect
Key Ctrl+RIGHT ARROW
Copy 
EndSelect
Key RIGHT ARROW
Key RIGHT ARROW
Clipboard 2
StartSelect
Key END
Copy 
NewFile
"SetupTest.exe /name="
Clipboard 1
Paste 
"
"
Clipboard 2
Paste 
"
Record "
Clipboard 1
Paste 
"
cleanup.exe
"
Clipboard 1
SaveAs "C:\test^c.cmd"
CloseFile

<now move down to second line and do almost the same.>
<repeat that until EOF. >

OUTPUT:

SetupTest.exe /name=12
"RunEngine1.exe test1.xml >> output.txt"
Record 12
cleanup.exe

rds Bego

Quadko · Nov 01, 2006#52006-11-01T02:53+00:00

Thanks, Bego!

UltraEdit, UltraCompare, UEStudio forums