I use an Android finance app that allows you to backup your transactions to later restore back to the app. I would like to explore the backup file but the file has no file extension and when I open the file in a text editor there is an issue with the character encoding.
SQLite format 3@ @y@.,Pˆ˚ˆïr9#ÅindexTransaction_CategoryIdTransactionCREATE INDEX "Transaction_CategoryId" on "Transaction"("CategoryId")o7#ÅindexTransaction_ProfileIdTransactionCREATE INDEX "Transaction_ProfileId" on "Transaction"("ProfileId")ÇX##ÑwtableTransactionTransactionCREATE TABLE "Transaction"( "Id" integer primary key autoincrement not null , "Type" varchar(10) , "Date" datetime , "Amount" float , "OccurrenceNumber" integer , "Recurring" integer , "Reconciled" integer , "Note" varchar(140) , "ProfileId" integer , "CategoryId" integer , "RecurringTransactionId" integer )P Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)ÅVÇtableCategoryCategoryCREATE TABLE "Category"( "Id" integer primary key autoincrement not null , "Name" varchar(140) , "Type" varchar(10) , "Icon" varchar(140) , "Colour" varchar(140) , "UsedCount" ˚˚lP ⁄∂âj6h„¡úvI"˙€∂ìE!%SellingIncome172-pricetag)-!Medical & DentalExpense10-medical!'Auto expensesExpense16-car#-Home FurnishingsExpense70-tv% MiscIncome172-pricetag&- ... ... ...
How can I convert this into a readable file?
CodePudding user response:
A program like this maybe useful: https://sqlitebrowser.org/