|
Server IP : 172.16.15.8 / Your IP : 13.59.112.169 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0705) : /home/tjpepper/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
#!/bin/bash
readFile=$1
#while read line
#do
# # Each line is $Line
# sed "s//" $line >$pokedex.sql
#done < $readFile
echo "INSERT INTO pokedex (kid,name,type1,type2) VALUES" > "pokedex.sql"
sed "s/[\t| ]*\([^\t^ ]*\)[\t| ]*\([^\t^ ]*\)[\t| ]*\([^\t^ ]*\)[\t| ]*\([^\t^ ]*\)[\t| ]*\([^\t^ ]*\)$/('\1','\2','\3','\4'),/g" $readFile >>"pokedex.sql"
echo ";" >>"pokedex.sql"