How can I generate sql inserts from pipe delimited data?

Posted by user568866 on Stack Overflow See other posts from Stack Overflow or by user568866
Published on 2011-01-09T15:40:37Z Indexed on 2011/01/09 15:53 UTC
Read the original article Hit count: 272

Filed under:

elisp

Given a set of delimited data in the following format:

1|Star Wars: Episode IV - A New Hope|1977|Action,Sci-Fi|George Lucas
2|Titanic|1997|Drama,History,Romance|James Cameron

How can I generate sql insert statements in this format?

insert into table 
   values(1,"Star Wars: Episode IV - A New Hope",1977","Action,Sci-Fi","George Lucas",0);
insert into table 
   values(2,"Titanic",1997,"Drama,History,Romance","James Cameron",0);

To simplify the problem, let's allow for a parameter to tell which columns are text or numeric. (e.g. 0,1,0,1,1)

Related posts about elisp

Manipulating columns of numbers in elisp

as seen on Stack Overflow - Search for 'Stack Overflow'
I have text files with tables like this: Investment advisory and related fees receivable (161,570 ) (71,739 ) (73,135 ) Net purchases of trading investments … >>> More
elisp compile, add a regexp to error detection

as seen on Stack Overflow - Search for 'Stack Overflow'
I am starting with emacs, and don't know much elisp. Nearly nothing, really. I want to use ack as a replacement of grep. These are the instructions I followed to use ack from within emacs: http://www.rooijan.za.net/?q=ack_el Now I don't like the output format that is used in this el file, I would… >>> More
emacs elisp buffer not running font lock mode until opened by user

as seen on Stack Overflow - Search for 'Stack Overflow'
My problem is I am opening a buffer using (set-buffer (find-tag-noselect (current-word))) and then I try to copy some text out of that buffer. The text that I get back has only the properties (fontified nil). find-tag-noselect automatically opens the buffer found in the TAGS file but it seems… >>> More
Elisp performance on Windows and Linux

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following dead simple elisp functions; the first removes the fill breaks from the current paragraph, and the second loops through the current document applying the first to each paragraph in turn, in effect removing all single line-breaks from the document. It runs fast on my low-spec… >>> More
elisp macro to write function?

as seen on Stack Overflow - Search for 'Stack Overflow'
hello I have written few functions, which nearly identical, save for names. For example ; x is name, such as function/paragraph/line/etc. (defun my-x-function (interactive) (mark-x) (do-more-stuff) (modify-x)) is there a way to put it automatically? I have a feeling this is what macros do,… >>> More

Developer IT

How can I generate sql inserts from pipe delimited data? - Developer IT

How can I generate sql inserts from pipe delimited data?

elisp

Related posts about elisp

Manipulating columns of numbers in elisp

elisp compile, add a regexp to error detection

emacs elisp buffer not running font lock mode until opened by user

Elisp performance on Windows and Linux

elisp macro to write function?

Categories cloud