Generate many XML files

[anthony]

Hi guys,

Wondering if any one out their has a solution to my query... I need to generate many (100+) variations of an XML file and was wondering if their is any tool (freeware) out there that you can use - was thinking of doing it in VBA(?)

[LondonManc]

Depends what your starting point is.

If you've got access to SQL Server you could write a cursor with a stored procedure call.

[WTFH]

Have you already got the schema and data, or are you supposed to be mocking up an output?

[RSoles]

Sounds like the sort of thing a python script should handle.

[VectraMan]

If it's Windows then I'm pretty sure you can do it with VBScript with Windows Scripting Host.

[DimPrawn]

Pretty vague request.

What is the source data?

When you say variations, do you mean variations of the data or variations of the structure?

[Bacchus]

You can do this with almost any programming language or scripting language.

in a simple case you could even do it with text in excel.

[Weltchy]

Notepad

[unixman]

Perl was designed specifically for this kind of thing.

[b0redom]

What UnixMan said. ^