XML to Delimited Text

[enigma333]

Need to ouput a recordset XML to a delimited Text file

RS =
rsField1
rsField2
rsField3

Text =
field1|field2|subfield1^subfield2|field3|

Transform

field2 = rsfield1
field1 = rsfield2
subfield1 = left(rsField2,2)

Something like that ... if that makes any sense to anyone

Basically I have to turn a recordset into a specifically delimited Text file and I would like to avoid using VB to loop through and place the elements in the right fields.

ideally I would have a xml template
a xml file that show the mapping between the RS fields and the template fields and would include some data translation code.

Is it possible.... What direction should i be taking with this

Thanks