I have a large Syslogchatchall text file and I want to convert it into database, I tried to open the file using Excel but all the information in a one log becomes one column. Is someone help me how I change that file into column based file. Thanks. syslog.txt
I suspected that the db import would fail due to the "loose" csv formatting.
I've added the use of the Text::CSV_XS (http://search.cpan.org/~hmbrand/Text-CSV_XS-1.11/CSV_XS.pm) module to fix the quoting
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity)
There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
In the distant past (last year) I hacked together a little toy that would allow a couple of Manager types to query, preview, and extract data from a number of MongoDB instances, to their tool of choice: Excel (http://dilbert.com/strips/comic/2007-08…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions.
Consider email address RFCs:
Look at HTML5 form input element (with type=email) regex pattern: