README.md


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48


rdb-to-sheets
A very simple python script to convert the TXT output from RDB to an Excel Sheet
How to use

On Meridian 1 do : LD 21; REQ PRT; TYPE RDB;
Copy the output from the first DN up to the last DN listed (see example below)
Save to somewhere as a raw txt
Use Bash script to set up Python3 VENV, or install requirements.txt things with pip on your system however you please.
Run : python3 ./rdb-to-sheets.py /your/rdb/file.txt 
Enjoy your now converted rdb excel sheet (made in same directory as rdb-to-sheets.py by default, can also be anywhere you desire python3 like this ./rdb-to-sheets.py /your/rdb/file.txt /your/output/rdb/sheet.xslx)

Example of RDB.txt file contents
DN   0
TYPE NARS
NTBL AC1 

DN   1000
TYPE RDB 
ROUT 0 

DN   1001
TYPE RDB 
ROUT 1

.
.
Rest of it goes here
.
.

DN   #37
TYPE FFC 
FEAT RGAD 

DN   #51
TYPE FFC 
FEAT SPCC 

DN   #54
TYPE FFC 
FEAT RDST 


Consideration

I know little coding and even less python, I've tested it on my Meridian 1 Option 11e only as thats the only system I own.
If you have suggestions on how to improve this feel free to submit those here.
If I made something completely wrong in the script its not my responsibility.
Have fun !