Skip to content

a bash script that uses awk and sed to create an sqlite database from "n" CSV files

Notifications You must be signed in to change notification settings

viviparous/sqliteCSVprep.sh

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

sqliteCSVprep.sh

a bash script that uses awk and sed to create an sqlite database from "n" CSV files

Created to build an SQLITE database file from MAXMIND GeoLite2 CSV files.

Will work with any CSV files.

Instructions:

= obtain CSV files that have a header row

= download this script and make it executable

= pass "n" CSV files to the script

= view the output; pipe to a file to save the output

= create the DB using the command: sqlite3 dbname.db < myoutput.sql

About

a bash script that uses awk and sed to create an sqlite database from "n" CSV files

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages