Showing posts with label LC_CTYPE. Show all posts
Showing posts with label LC_CTYPE. Show all posts

Tuesday, June 14, 2022

warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No such file or directory fixed

$ cat /etc/environment

LANG=en_US.utf-8 
LC_ALL=en_US.utf-8


For CentOS:

sudo vi /etc/environment
add the following  lines:
LANG=en_US.utf-8
LC_ALL=en_US.utf-8

Or, 
export LC_CTYPE=en_US.UTF-8 
export LC_ALL=en_US.UTF-8

or 
vi  .bash_profile

then add the following lines:

export LC_CTYPE=en_US.UTF-8 
export LC_ALL=en_US.UTF-8

Extract Domain from email in Excel or Google sheet

  =TEXTAFTER( A2 , "@") or, =MID(A1, FIND("@", A1) + 1, LEN(A1) - FIND("@", A1))