From Excel to notepad (.txt)

[Undertegnede]

Hi,

I wanted to see if anyone knew a way to convert a dataset from Excel to notepad (.txt). I need data in .txt format in order to import it to our ERP-system (UBW.

The input would look like this (9 columns, usually a couple thousand rows):

[TABLE="width: 500"]
<tbody>[TR]
[TD]10[/TD]
[TD]1000[/TD]
[TD]SKOST[/TD]
[TD]300,5[/TD]
[TD]1000[/TD]
[TD]B3[/TD]
[TD]K01[/TD]
[TD]01.10.2018[/TD]
[TD]30.09.2019[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]2000[/TD]
[TD]SKOST[/TD]
[TD]450,1[/TD]
[TD]1000[/TD]
[TD]B3[/TD]
[TD]K02[/TD]
[TD]01.10.2018[/TD]
[TD]30.09.2019[/TD]
[/TR]
</tbody>[/TABLE]


Output (in .txt) should look like this (each column from Excel is split by X-number of spaces):

10 1000 SKOST 300C5 1000 B3 K01 2018100120190930
30 2000 SKOST 450C1 1000 B3 K02 2018100120190930



Best regards

 

[sandy666]

save as .txt ?