Large CSV File

For large cvs file (for example system, application event log) may have difficulties while launch in excel. Here is a vbs script to cut the files to 60000 rows to prevent execl limitation of 65,536 rows - File not Loaded completely message.

If you wish u can modify the rows of a file by "Line32: if (i = 60000) then", which can make the file smaller.

Download

by Link
http://cid-8167344592f7bd22.skydrive.live.com/self.aspx/Public/Cutcsv.vbs

Comments

Post a Comment

Popular posts from this blog

Openshift cert-manager integrate with ACME IdM on RHEL (Technical Preview)

Image
Explore ACME on IdM Redhat IPA (freeipa) AMCE in technical preview  The Automated Certificate Management Environment (ACME) service is now available in Identity Management (IdM) as a Technology Preview. <- RHEL 9.1 https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/9/html-single/9.1_release_notes/index#technology-preview_identity-management In RHEL 9.2. ACME now supports automatically removing expired certificates, but no mention about it is GA https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/9/html-single/9.2_release_notes/index#technology-preview_identity-management In RHEL 9.3 ACME available as a Technology Preview https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/9/html-single/9.3_release_notes/index#technology-preview_identity-management P.s. IdM is a software that comes with RHEL. only need one RHEL subscription. It supports replica (like MS domain controllers replication), but for simple setup, we may consider...
Read more

TimeSync using ansible and rhel-system-roles.timesync

Install   rhel-system-roles.timesync yum install rhel-system-roles -y After install  /usr/share/ansible/roles/rhel-system-roles.timesync [root@servera ~]# cat inventory   [all] server[a:e] [root@servera ~]# ansible -i inventory all -m ping   servere | SUCCESS => {     "changed": false,       "ping": "pong" } serverb | SUCCESS => {     "changed": false,       "ping": "pong" } servera | SUCCESS => {     "changed": false,       "ping": "pong" } serverd | SUCCESS => {     "changed": false,       "ping": "pong" } serverc | SUCCESS => {     "changed": false,       "ping": "pong" } [root@servera ~]# cat timesync.yml   --- - hosts: all   vars:     timesync_ntp_servers:       - hostname: {IP of NTP 1}     ...
Read more

Remove HPE iLO license

Image
It spend me sometime to reserch how to remove iLO advance license and use HPE OneView Advanced. Here is the solution. 1. download HP Lights-Out configuration Utility https://support.hpe.com/hpsc/swd/public/detail?sp4ts.oid=null&swItemId=MTX_8abe539b67bf46978e8f84acb8&swEnvOid=4184#tab1 2. run the command with xml "C:\Program Files (x86)\Hewlett Packard Enterprise\HP Lights-Out Configuration Utility\HPQLOCFG.exe" -s 10.10.100.43 -f C:\Users\chengwi\Desktop\ilo.xml HP Lights-Out Configuration Utility - HPQLOCFG v5.2.0.0 dated 12/18/2017 (c) 2013, 2017 Hewlett Packard Enterprise Development LP Detecting iLO.... Negotiated cipher:168-bit TripleDes with 160-bit Sha1 and 1024-bit RsaKeyX .... Script succeeded for IP:10.10.100.43:443 ilo.xml      
Read more