Jump to content
Sign in to follow this  
tommytx

How to extract data to be used by mysql.

Recommended Posts

tommytx

1099,"Run Fast, San Mateo",maple-san-mateo,"<p><iframe src=""//www.youtube.com/embed/x8jjLXztN0g?rel=0"" width=""420"" height=""315""></iframe></p>",2,True,True,2013-07-24 21:41:00,2013-07-24 21:41:36,2013-07-24 21:41:36,,,,[30L]
 

The above is a line from the export of a mysql data base exporting in the CSV mode comma separated.

Does anyone have any idea if a script exits that can pull the data out without major coding...

I suppose I could import it into a mysql data base then export it with semicolon or some unique character... but right now its exported in comma mode..so difficult to load it correctly in to autoit.. for example there is comma's inside the quotes so that will need special handling.. and there is the double quote problem...

I want to do something like a stringsplit at the commas, but there is commas inside the quotes and I want to keep the commas between the quotes and not do stringsplit on commas inside the quotes....

Any idea for  scripts...or something that would do this...

Thanks..

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×