Advertisement
Guest User

Untitled

a guest
Mar 8th, 2015
314
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. Sed File:
  2. s|\([A-Z]*\),\([A-Z]*\),\([A-Za-z0-9’ ()\.\!-]*\),\([A-Za-z0-9’ ()\.\!-]*\),\([0-9]*\)|INSERT INTO `Schedule` (`ID`,`YEAR`,`NUMBER`,`TeamR1`,`TeamR2`, `TeamR3`, `TeamB1`, `TeamB2`, `TeamB3`) VALUES ('\1', '\2', '\3', '\4', '\5', '\6', '\7', '\8', '\9');|g
  3.  
  4. CSV File (part of it):
  5. 1,2015,0,57,3310,3676,624,3802,3481
  6.  
  7. Console Error:
  8. sed: file csv2sql.sed line 1: invalid reference \9 on `s` command's RHS
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement