admin
How to extract number from a string – google sheets
Sample usage to remove string prefix and extract remaining number in suffix. The outcome will be
Alternatives Apps for 59 Banned Chinese Apps
Indian Government banned 59 Chinese apps due to sovereignty, integrity and security of the country. Here’s the full list of Banned Apps with Best available read more
Linux ping a port using netcat
To check if a port is reachable on Linux This is tested using nc version 7.50 (package nmap-ncat) on Amazon Linux. nc -vz localhost 22Connection read more
Use watch to monitor a command at some frequency on Linux
Use watch with -n to watch a command ever 2 seconds. e.g. To watch top command with first 12 lines every 2 seconds:watch -n 2 read more
Linux what package provides a file
Using rpm We can use rpm on Centos/RHEL/Amazon Linux based system to file which package provides a specific file. e.g. rpm -q -f /usr/bin/watchprocps-3.2.8-45.16.amzn1.x86_64 Alternatively read more
Corporate Debt vs Gilt fund – which one is better?
What are corporate debt mutual funds? Debt mutual fund mostly invest in corporate debt instruments (NCD, etc) with various maturity periods depending upon the type read more
csvkit – parse csv file and data on Linux command line
csvkit can be used to extract and process fields from a csv file on Linux or Mac. Install python3 if not installed already. The command read more
Linux replace comma with newline
To replace comma of any other character with newline on Linux or Mac, the following tr command can be used tr ‘,’ ‘\n’ filename or read more
mysql – how to enable query logs
The steps to enable mysql query logs on Mysql 5.7 (should work on other versions also) on Linux Edit /etc/my.cnf and add the followinggeneral_log=1general_log_file=/var/log/mysqlquery.log Ensure read more
mysql find recently created-tables
The query to find recently created tables in mysql select table_schema, table_name, create_timefrom information_schema.TABLESwhere table_schema not in (‘information_schema’, ‘mysql’)order by CREATE_TIME desc
