Usually LIbreoffice gets it right, but if it opens a normal English CSV as UTF-16 by default and shows Asian languages, you'll have ot manually open to fix it (don't double click the file from the File Manager). Solution - Manually Open the File After Opening LibreOffice Calc You'll see it is defaulting to UTF-16 which breaks everything. ........

Just edit your ~/.bashrc and add this at the very end: export PS1="realtechtalk.com" Then your prompt will look like this: bladeblox:uptime 08:47:14 up 48 min, 1 user, load average: 1.00, 1.07, 0.96 If you wanted a dollar sign at the end then you would change it like this: export PS1=&........

It seems that QEMU/KVM's default PS2 mouse and keyboard doesn't work right in most cases. I have especially observed issues using Ctrl+C and Ctrl+V and in Linux you may see repeated key presses in the terminal and you will wonder why you copied something and it's not in the clipboard when you try to paste. The way to temporarily fix it is to press the key that is repeating once(works in Linux but not really in Windows). Sometimes when moving your mouse it will also s........

yum -y install gcc make gperf genisoimage flex bison ncurses ncurses-devel pcre-devel augeas-devel augeas readline-devel checking for cpio... cpio checking for gperf... no configure: error: gperf must be installed configure: error: Package requirements (augeas >= 1.2.0) were not met: Requested 'augeas >= 1.2.0' but version of augeas is 1.0.0 yum remove augeas augeas-libs augeas-devel wget http://downl........

This is all controlled by /etc/issue You can basically enter anything in there that you like, but there are preset variables that are mentioned at the end of the page that discuss this. Some examples of /etc/issue: Centos 7: S Kernel r on an m Ubuntu 16.04: Ubuntu 16.04.6 LTS n l You can also insert any of t........

When using strip_tags and html_entity_decode with PHPit often breaks and produces annoying diamonds with question marks. It is probably because of characters like these: … (looks like 3 dots but it is a single weird character). ’ (looks like a normal apostraphe but it is not) ” (looks like a normal double quote but it is not). An easy way to sort this out is to copy the above and search in an ASCII table to extend the functional........

This is often the result of PayPal's "item name" or another name having invalid characters or not supporting Unicode. 173.0.81.1 - - [17/Jul/2018:13:39:45 -0400] "POST //modules/gateways/callback/paypal.php HTTP/1.1" 406 - "-" "PayPal IPN ( https://www.paypal.com/ipn )" A good clue is if you check the debug output of the IPNand find a mandatory column empty. ........

#mount the VCSA DVD mount /dev/sr0 /mnt/cd #alternatively you could mount the iso directly mount -o loop vcsa.iso /your/mount/path #for this purpose we are using the CLI installer on Linux cd /mnt/cd/vcsa-cli-installer/lin64 #no it's not going to be that easy you can't just run vcsa-deploy like that you need to use a template or configured .json file ./vcsa-deploy Usage: vcsa-deploy [-h] [--version] [--supported-deploymen........

The reason for this article is because a lot of us don't physically see our hard drives they are often remote in a datacenter etc and the actual serial number we see in SMART is not enough to check for some manufacturers. A good example is our first one the Toshiba === START OF INFORMATION SECTION === Device Model: TOSHIBA DT01ACA200 Serial Number: 33FMDW4AS........

$title_clean = substr($title,0,-3); In the above example the last 3 characters will be removed from the string "$title". You can of course have the last X removed by changing -3 to -X........

This happens on any file an even just typing "vi"whereas it never happened before. I suspect an update or environment variable is causing this issue When entering vi I get this weird stuff line 58: E488: Trailing characters: t_Sbet line 63: E171: Missing :endif When exiting vi I get this weird stuff t_Sb=^[[4%?%p1%{1}%=%t........

This command will generate a random password using all letters and numbers that is 20 characters wrong based on /dev/urandom (for the most truly random output). echo `< /dev/urandom tr -dc _A-Z-a-z-0-9 | head -c${1:-20};echo;`........

Very useful in embedded and other non-standard deployments. The above makes a random salt of 14 random characters from /dev/urandom (you can change the -14 to whatever number of characters you want for your salt). openssl passwd -1 -salt `< /dev/urandom tr -dc _A-Z-a-z-0-9 | head -c${1:-14};echo;` YourPassword Output: $1$eW-ScuyL$f/iKMJ5mbJ..7bSzvX6EO0 How To Create Password Has........

variable="abc hello" How do you count it (note blank/white space counts as a character too)? echo "${#variable}" 9........

Debian/Ubuntu vi keyboard problem, up and down arrows do not work and instead make an A (Up), B (Down), C (Right) or D(Left). The working solution (you could also add the set nocompatible to /etc/vim/vimrc to make it system wide-will not be applied until reboot I believe): echo "set nocompatible" > ~/.vimr........

Say you have a bunch of files like this: file-01.jpg file-02.jpg ............... What if you want to mass rename them? the rename tool can work just like sed For Debian based distros: Note "file" is what we search for and "newname" is what we replace it with, so substitute according to your requirements. rename s/file/newname/ name-file-*.jpg For R........

------------------------------------- ProCurve J4903A Switch 2824 Software revision I.10.77 Copyright (C) 1991-2009 Hewlett-Packard Co. All Rights Reserved. RESTRICTED RIGHTS LEGEND Use, duplication, or disclosure by the Government is subject to restrictions........

sed -i 's/[d128-d255]//g' file.txt........

#remove non english characters from file: sed -i 's/[d128-d255]//g' file.txt........

htpasswd -b -c filename username "password" -b = take the password that we specify in the command (don't prompt for it) -c = create the filename username=username password=password (I use quotes because it breaks if you use special characters)........

This is basically URL decoding to the decimal code but nothing in PHPworks how you'd expect it. Here are online tools to verify and check your work, it's important when querying databases with non-English characters: http://yehg.net/encoding/index.php# http://meyerweb.com/eric/tools/dencoder/ http://www.codetable.net/decimal/65398 Japanese: http://symbolcodes.tlt.psu.edu/bylanguage/japanesechartkatakana.html Charat code for PHP:........

$newlist=str_replace("_"," ",$list); The example above searches the "$list" string and replaces any "_" with a blank space "". ........

This may sound silly but there will be conflicts/issues with the default Centos repository so you have to use a third party like remi (I prefer not to do this but it's the only option unless you migrate your sites/data to another server or can stand some downtime-not an option IMHOon a production server). You may need to upgrade to PHP5.3 to run Joomla or many other reasons. Your host needs to use PHP 5.2.4 or higher to run this version of Jo........

ERROR 1045 (28000): Access denied for user 'contentmanager'@'localhost' (using password: YES) For fun I thought I'd reset the password: GRANT ALL ON thecontent.* TO contentmanager IDENTIFIED by 'dfdfsdfdsfsdfsd'; ERROR 1470 (HY000): String 'contentmanager' is too long for user name (should be no longer than 16) This is ridiculous that this new version has some bizarre 16 character username limit and not only that but i........

In bash you test like this for problems that can be caused by non-printable characters since if you don't know how to identify it because it basically breaks your script. echo "url=$url" should print something like this normally if you have properly formatted input/text: url=::http://someaddress.com:: But if you have some weird hidden characters (not visible in a text editor of any sort you'll get something like this ::l=::http://s........

Webmin Setup Centos 5: wget http://downloads.sourceforge.net/project/webadmin/webmin/1.530/webmin-1.530-1.noarch.rpm?r=http%3A%2F%2Fwww.webmin.com%2Fstandard.html&ts=1294339690&use_mirror=surfnet [1] 24229 [2] 24230 [root@host ~]# --2011-01-06 21:48:20-- http://downloads.sourceforge.net/project/webadmin/webmin/1.530/webmin-1.530-1.noarch.rpm?r=http%3A%2F%2Fwww.webmin.com%2Fstandard.html Resolving downloads.sourceforge.net... 216.34.181.........

I thought there would be an error message or warning from MySQL in the case that the text you submit is greater than the allowed limit based on the field. So essentially I submitted text that was about 120,000 characters long, whereas the limit of TEXT is just 65,535 characters! I almost lost half of my data/what I typed without knowing it! I just altered the field type in my database from TEXT to LONGTEXT. I can't see how LONGTEXT wouldn't be long enough for MOST........

Iused to get all kinds of weird annoying characters like "â" during compilation with gcc especially. example: dmg2img.c:456: error: âBZ_OKâ undeclared (first use in this function) dmg2img.c:471: warning: implicit declaration of function âBZ2_bzCompressEndâ dmg2img.c:482: warning: implicit declaration of function âBZ2_bzDecompressâ dmg2img.c:484: error: âBZ_PARAM_ERRORâ undecl........