This question is regarding the best way to add delimiters to a flat (text) file
so that it will be a CSV file so that I can use phpMyAdmin to read in the data.
Data Example below with ^ as field separator and + as line termination:
##Sample of text before field separators and line termination characters ####
This is an example of output from a Perl scripted guestbook. The entries are sent as HTML. I simply copied and pasted the results of the HTML file to a text file. This is the way the entries look in the text file. The first field is the comment field, then name, theatre, location and date/timestamp.
Full Name here <Theatre Field>
Chicago, IL USA - Wednesday, August 01, 2001 at 02:26:48 (CDT)
This would be the next sequential entry, etc. I have over 1500 of them to date. My goal is to find a program that will add the carrot ^ characters after each field and a plus + character for the line termination so that all 1500 plus entries may be inserted into a MySQL table using phpMyAdmin.
I have successfully done this with about 5 entries. My problem is finding a program or learning how to create one that will insert the ^ as a field separator and + as a line terminator. Can someone please help me in this? Thank you.
Derrick<Aerial Theatre>
Houston, TX USA - Wednesday, August 01, 2001 at 10:55:47 (CDT)
##Sample after field separators and line termination characters added ##
This is an example of output from a Perl scripted guestbook. The entries are sent as HTML. I simply copied and pasted the results of the HTML file to a text file. This is the way the entries look in the text file. The first field is the comment field, then name, theatre, location and date/timestamp.
^Full Name here ^<Theatre Field>
^Chicago, IL USA - ^Wednesday, August 01, 2001 at 02:26:48 (CDT)+
This would be the next sequential entry, etc. I have over 1500 of them to date. My goal is to find a program that will add the carrot ^ characters after each field and a plus + character for the line termination so that all 1500 plus entries may be inserted into a MySQL table using phpMyAdmin.
I have successfully done this with about 5 entries. My problem is finding a program or learning how to create one that will insert the ^ as a field separator and + as a line terminator. Can someone please help me in this? Thank you.
^Derrick ^<Aerial Theatre>
^Houston, TX USA - ^Wednesday, August 01, 2001 at 10:55:47 (CDT)+
so that it will be a CSV file so that I can use phpMyAdmin to read in the data.
Data Example below with ^ as field separator and + as line termination:
##Sample of text before field separators and line termination characters ####
This is an example of output from a Perl scripted guestbook. The entries are sent as HTML. I simply copied and pasted the results of the HTML file to a text file. This is the way the entries look in the text file. The first field is the comment field, then name, theatre, location and date/timestamp.
Full Name here <Theatre Field>
Chicago, IL USA - Wednesday, August 01, 2001 at 02:26:48 (CDT)
This would be the next sequential entry, etc. I have over 1500 of them to date. My goal is to find a program that will add the carrot ^ characters after each field and a plus + character for the line termination so that all 1500 plus entries may be inserted into a MySQL table using phpMyAdmin.
I have successfully done this with about 5 entries. My problem is finding a program or learning how to create one that will insert the ^ as a field separator and + as a line terminator. Can someone please help me in this? Thank you.
Derrick<Aerial Theatre>
Houston, TX USA - Wednesday, August 01, 2001 at 10:55:47 (CDT)
##Sample after field separators and line termination characters added ##
This is an example of output from a Perl scripted guestbook. The entries are sent as HTML. I simply copied and pasted the results of the HTML file to a text file. This is the way the entries look in the text file. The first field is the comment field, then name, theatre, location and date/timestamp.
^Full Name here ^<Theatre Field>
^Chicago, IL USA - ^Wednesday, August 01, 2001 at 02:26:48 (CDT)+
This would be the next sequential entry, etc. I have over 1500 of them to date. My goal is to find a program that will add the carrot ^ characters after each field and a plus + character for the line termination so that all 1500 plus entries may be inserted into a MySQL table using phpMyAdmin.
I have successfully done this with about 5 entries. My problem is finding a program or learning how to create one that will insert the ^ as a field separator and + as a line terminator. Can someone please help me in this? Thank you.
^Derrick ^<Aerial Theatre>
^Houston, TX USA - ^Wednesday, August 01, 2001 at 10:55:47 (CDT)+