i think the "9" stands for tab

but i cannot replace for "," because certain data may contain ","

i really don't know anything about XSL
could you( or anyone else ) help me with the howto's in a XSL ??

for sure is that the <COLUMNS> part is the key, because that will the field 
descriptor
the <DATA> is the records

grtz, Paul


"skar" <skarface4@h...> wrote in message 
news:uKgi5O61EHA.1260@T......
>I don't have much experience in compact xml, but this may work:
> Questions the attribute Char="9" what does it mean? Well whatever it means
> we can use that as the delimiter.  Assuming it means 9 spaces (which is 
> not
> the case!!)
>
> you can write an xsl to extract the info contained in this xml and 
> transform
> the content to a csv file.  The key will be in modifying char="9" 
> delimiter
> to ","
> your csv file can then be imported into access or any other db.
>
> good luck
> Skar
> "Paul de Vries" <paul.de.vries@t...> wrote in message
> news:QPgrd.6071$_F1.357467@p......
>> hi guys, i got a weird thing
>>
>> some server gives back COMPACT XML
>>
>> that means
>>
>> <ROOTNODE>
>> <DELIMITER Char="9"/>
>>     <COLUMNS>    Column1    Column2    Column3    Column4    Column5
>> </COLUMNS>
>>     <DATA>    Data1    Data2    Data3    Data4    Data5    </DATA>
>>     <DATA>    Data11    Data21    Data31    Data41    Data51    </DATA>
>>     <DATA>    Data12   Data22   Data32    Data42    Data52    </DATA>
>>     <DATA>    Data13    Data23    Data33    Data43    Data53    </DATA>
>>     <DATA>    Data14    Data24    Data34    Data44    Data54    </DATA>
>>     <DATA>    Data15        Data35        Data54    </DATA>
>> </ROOTNODE>
>>
>> I understand this schema myself, but how can i
>>
>> how would i be able to store this information in a database, either
> MS-SQL,
>> Microsoft Access
>>
>> thanx for brainstorming with me
>>
>> grtz, Paul
>>
>>
>
>