Undertegnede
New Member
- Joined
- Oct 15, 2013
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
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):
<tbody>
</tbody>
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
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):
10 | 1000 | SKOST | 300,5 | 1000 | B3 | K01 | 01.10.2018 | 30.09.2019 |
30 | 2000 | SKOST | 450,1 | 1000 | B3 | K02 | 01.10.2018 | 30.09.2019 |
<tbody>
</tbody>
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
Last edited: