Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by evkruining
-
Convert flat file to sql script
I've tweaked Stefans code a bit to make it a one liner that I can include into another script that does the mysql import too. The thing with the double qoutes also works out very well. The line I use now is: sed "s/^\(..\) /INSERT INTO playlist VALUES ($1, \1, \"/g;s/ - /\", \"/g;s/$/\");/g"...- evkruining
- Post #6
- Forum: UNIX Scripting
-
Convert flat file to sql script
Hi, I would like to automatically convert a plain text file containing a playlist to a sql script to import the proper data into an existing table. I'm running a linux server with all these powerful built-in tools like awk, sed and grep but I don't know how to use them proper. I guess a fancy...- evkruining
- Thread
- Replies: 5
- Forum: UNIX Scripting
