How to load this <level id="1">Aa; Bb; Cc; Dd; Ee; Ff;</level> from a RSS /XML/ ?

[ivan_will]

<title>ID</title>

<code>CODE</code>

<date>DATE AND TIME</date>

<level id="1">Aa; Bb; Cc; Dd; Ee; Ff;</level>

And wondeing how to load the data from <level id="1">Aa; Bb; Cc; Dd; Ee; Ff;</level>? Want Aa, Bb , Cc ... to be in different field (column)!!!

Code Date Aa Bb Cc ...

12 2010 2.1 3.5 1.3

15 2010 11 1.2 7.3

......................................................

Could anyone tell me if there is a way to do this ?

Thanks!

[ivan_will]

Any Ideas?

[#3]

Hi

Looks like a crosstable load. Can you post a small data extract to let us see more of it?

Regards

Juerg