CODEWITHSUNDEEP
xmlvb.netxsdflat-file
ʃʈɑɲ
ʃʈɑɲ

Reputation: 2684

Transform flat datatable to dataset using XSD

Can anyone advise me if this is possible?

I have data in textform that looks like this:

...
^GLOBAL HDORDNOLBL
^GLOBAL HDORDNO
^GLOBAL ORDDATLBL
Orderdatum
^GLOBAL ORDDAT
01/06/12
^GLOBAL INVDATLBL
Fact.datum
^GLOBAL INVDAT
05/06/12
^GLOBAL COUNTRYLBL
^GLOBAL COUNTRY
Belgium
^GLOBAL CUSNOLBL
Klantennummer
^GLOBAL CUSNO
AL8985
...

I'll be putting this in a flat datatable with ^[ITEM] being a field and [VALUE] being the value. I can manage this BUT... I would like to transform this datatable into a dataset based on certain rules. Basically, what I want to do is make a structured dataset from flat data. What is the best way to do this?

Upvotes: 1

Views: 397

Answers (1)

Paul Sweatte
Paul Sweatte

Reputation: 24617

Use find/replace to change the delimiters to CSV format, import the flat file into Excel as CSV, then use a VBA macro to convert it to XML using the XSD.

Upvotes: 1

Related Questions