Simple Python Script to convert RDB terminal printout to Excel Sheets
  • Python 97.2%
  • Shell 2.8%
Find a file
Repository files (latest commit first)
Filename Latest commit message Latest commit date
2025-02-10 16:00:19 +01:00
.gitignore Added example rdb.txt file contents 2025-02-10 07:27:49 +01:00
LICENSE Gave MIT license 2025-02-10 15:59:32 +01:00
rdb-to-sheets.py more typos 2025-02-10 07:16:48 +01:00
README.md Updated README and Omitted redundant line 2025-02-10 16:00:19 +01:00
requirements.txt initial commit 2025-02-10 07:01:44 +01:00
setup.sh initial commit 2025-02-10 07:01:44 +01:00

rdb-to-sheets

A very simple python script to convert the TXT output from RDB to an Excel Sheet

How to use

  1. On Meridian 1 do : LD 21; REQ PRT; TYPE RDB;
  2. Copy the output from the first DN up to the last DN listed (see example below)
  3. Save to somewhere as a raw txt
  4. Use Bash script to set up Python3 VENV, or install requirements.txt things with pip on your system however you please.
  5. Run : python3 ./rdb-to-sheets.py /your/rdb/file.txt
  6. 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

  1. 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.
  2. If you have suggestions on how to improve this feel free to submit those here.
  3. Have fun !