CSV Splitter

Found this very useful CSV file splitter for files over 65536 rows (excel before 2007) or 1048576 rows (excel 2007+).
See the original forum thread here or download here

Comments

Post a Comment

Popular posts from this blog

qshape command not found - Postfix

To use qshape you need to install postfix-perl-scripts below are the commands for the major distros Fedora/Centos/Redhat yum install postfix-perl-scripts Debian, Ubuntu apt-get install postfix-perl-scripts Mandriva urpmi postfix-perl-scripts Suse yast -i  postfix-perl-scripts If this won install or wont run once installed then you may need to install perl, use the commands above but replace postfix-perl-scripts with perl Original Source: http://jerrylparker.com/?p=56
Read more

Custom Form Error in Symfony 5 (form_errors)

While you can add attributes to form_label and form_widget to customise form_errors you have to use a template. Add a twig template "templates/form/form_errors.html.twig" Paste in the below {% block form_errors %}     {% if errors|length > 0 %}     <ul class="error_list">         {% for error in errors %}             <li>{{ error.message }}</li>         {% endfor %}     </ul>     {% endif %} {% endblock form_errors %} Edit "config/packages/twig.yaml" Add in the template details eg. twig:     default_path: '%kernel.project_dir%/templates'     form_themes:         - 'form/form_errors.html.twig' Based on Symfony 2 instructions found here
Read more

Using variables within ajax success function that were set before ajax call (JQuery)

I spent several hours trying to access variables that were set before an Ajax call, turns out there is a simple solution. To be able to access the variables you need to set them as parameters within the Ajax call and then to access them in the success function you prefix them with "this." eg. var a = 1; $.ajax({             type: "POST",             contentType: "application/json; charset=utf-8",             url: "theurl.com",             data: '{a: a}',             dataType: "json",             a: a,             success: function (msg) {          ...
Read more