Linux Resources
- Home
- Linux Resources
Remove Duplicates in LibreOffice - Step by step process to do it ?
This article will guide you on how to get rid of duplicates from either the single column or from the multiple columns in LibreOffice. Removing duplicate entries is necessary to clean up the data. With LibreOffice advanced filter tool, you can easily remove these duplicate values from your data.
You can use Libre Office to open and edit existing #MS Office documents like excel word power point etc.
Libre Office is a free alternate to MS #office and offers same functionality. Its easy to install and use.
The #VLOOKUP function (short for Vertical LOOKUP) is a built-in Calc function that is designed to work with data that is organized into columns.
For a specified value, the function finds (or looks up) the value in one column of data, and returns the corresponding value from another column.
To find duplicates in #LibreOffice Calc:
1. Go to the worksheet that has the duplicate entries, and select 'Data' > 'Filter' > 'Standard Filter' (it seems to automatically select the data in the sheet that it will filter, you may want to do this manually beforehand).
2. It should then filter the data, and hide any duplicate records.
To insert a date in Libreoffice #Calc:
To enter a current date as a static date, press CTRL+; (semicolon). It will insert today's date as a static value in the corresponding cell.
Similarly to enter current time as staic value, press CTRL+SHIFT+; .
Methods to Find your Private IP Address in Debian 10 ?
This article will guide you on the different methods through which you can easily figure out the private IP #address of your Debian 10 system.
The network statistics ( netstat ) command is a networking tool used for troubleshooting and configuration, that can also serve as a monitoring tool for connections over the network. Both incoming and outgoing connections, routing tables, port listening, and usage statistics are common uses for this #command.
To find out the #IP address of #Linux system, you need to use the command called ifconfig on #Unix and the ip command or hostname command on Linux.
To get you the private IP address of your interfaces:
i. ifconfig -a.
ii. ip addr (ip a).
iii. hostname -I | awk '{print $1}'.
iv. ip route get 1.2.
v. (Fedora) Wifi-Settings - click the setting icon next to the Wifi name that you are connected to - Ipv4 and Ipv6 both can be seen.
vi. nmcli -p device show.
Different methods to Reboot Ubuntu 20.04 LTS ?
This article will guide you on the different methods through which you can effectively reboot your #Ubuntu 20.04 system without any difficulty.
To #reboot immediately, append the -r flag: $ sudo shutdown -r now.
To power down immediately: $ sudo shutdown -P now.
You can use the poweroff #command: $ poweroff.
To reboot after 10 minutes: $ sudo shutdown -r 10.
To reboot Linux using the command line:
1. To reboot the Linux system from a terminal session, sign in or "su"/"sudo" to the "root" account.
2. Then type " sudo reboot " to reboot the box.
3. Wait for some time and the Linux server will reboot itself.
Display System and Hardware Details in CentOS 8 - How to do it ?
This article will guide you on different methods to retrieve information about your #Linux system and the underlying #hardware devices. These procedures will help you check the specifications of your computer machine and you can easily know either the hardware device or computer software is compatible with your working system or not.
The Linux kernel is the main component of a Linux operating system (OS) and is the core interface between a computer's hardware and its processes.
To find system information in #Centos:
1. To know only system name, you can use uname command without any switch will print system information or uname -s #command will print the kernel name of your system.
2. To view your network hostname, use '-n' switch with uname command as shown.
3. To get information about kernel-version, use '-v' switch.
Display System and Hardware Details in Debian 10 - How to do it ?
This article will guide you how to display the system details in your Debian 10 system.
The uname command Displays the operating system name as well as the system node name, operating system release, operating system version, hardware name, and processor type.
To Check os version in Linux:
1. Open the terminal application (bash shell).
2. For remote server login using the ssh: ssh user@server-name.
3. Type any one of the following command to find os name and version in Linux: cat /etc/os-release. lsb_release -a. hostnamectl.
4. Type the following command to find Linux kernel version: uname -r.
Commands to Check Hardware Information on Linux:
i. lscpu. The lscpu command reports information about the cpu and processing units.
ii. lshw - List Hardware. will give you a very comprehensive list of hardware and settings.
iii. hwinfo - Hardware Information.
iv. lspci - List PCI. will show you most of your hardware in a nice quick way.
v. lsscsi - List scsi devices.
vi. lsusb - List usb buses and device details.
vii. Inxi.
viii. lsblk - List block devices.
Install Linux, Apache, MariaDB, PHP (LAMP) Stack on Debian 10 - Step by step process to do it ?
This guide will help you on how to #install the LAMP stack (Linux, Apache, MariaDB, and PHP ) in your #Debian system.
LAMP stands for Linux, Apache, MySQL, and PHP. Together, they provide a proven set of software for delivering high-performance web applications.
For a web application to work smoothly, it has to include an operating system, a web server, a database, and a programming language.
A LAMP Stack is a set of open-source software that can be used to create websites and web applications.
LAMP is an acronym, and these stacks typically consist of the Linux operating system, the Apache HTTP Server, the MySQL relational database management system, and the PHP programming language.
To Install #LAMP stack on Ubuntu:
1. Update your system. sudo apt-get update.
2. Install Mysql. sudo apt-get install mysql-server mysql-client libmysqlclient-dev.
3. Install #Apache server.
4. Install #PHP (php7.0 latest version of PHP).
5. Install #Phpmyadmin (for #database).
