I have used the following method to check for and fix misspelled words in a SQLite database.
Note: This was for a database with less than 500 records1) Load the database into DB Browser (SQLite)
2) Select the columns you want to perform the spellcheck on and copy
3) Paste into a blank spreadsheet
4) Do a spellcheck in the spreadsheet
5) Make a note of the records with misspelled words.
6) Correct those records in DB Browser
No comments:
Post a Comment