I am new to XML use inside SQL Fields. I have the following field example (can contain anywhere from 12 - 30 variables) that I need to convert the contents of this field for all rows into a table with headers.
I have read a slew of forums and can't find anything that does what I'm looking for - maybe I am using the wrong terms? Any advice would be greatly appreciated. ---SAMPLE--- (the leading "(" is really a < but the HTML generator strips out the code if I leave it in)
expected result: Tag Descriptor Message Date Units DampingValue (etc) GENERIC NULL NULL 10-25-2002 InH20 0.000
asked Sep 17, 2012 at 01:18 PM in Default
Try this. However, there are 2 things you must do. You must do a global replace on "variable index" and replace with "row variableindex" You need the row indicator to get the row right and the script chokes on spaces in the column names.