Contatenate text to Date to Sort

Convert 01.01.2024  to 01/01/2024 to count as date in Excel.

 =DATE(RIGHT(A2,4),MID(A2,FIND(".",A2,1)+1,FIND(".",A2,FIND(".",A2,1)+1)-FIND(".",A2,1)-1),MID(A2,1,FIND(".",A2,1)))

How to install Plesk on Ubuntu 22.00 using a single command

 # sh <(curl https://autoinstall.plesk.com/one-click-installer || wget -O - https://autoinstall.plesk.com/one-click-installer)

Toshiba e studio 2829a print using lan cable without router

 To set up a Toshiba e-STUDIO 2829A printer to print using a LAN cable without a router, you'll need to directly connect the printer to your computer with an Ethernet cable and configure both devices to communicate with each other. Here's how you can do it:

1. Connect the Printer to the Computer:

   • Plug one end of the Ethernet cable into the LAN port of the Toshiba e-STUDIO 2829A.
   • Plug the other end of the Ethernet cable into the Ethernet port of your computer.

2. Set Static IP Addresses:

   • Since there is no router to assign IP addresses dynamically, you need to set static IP addresses for both the printer and the computer.

3. Configure the Printer’s IP Address:

   • Access the printer’s control panel.
   • Navigate to the network settings (this can usually be found under Admin or System settings).
   • Set a static IP address for the printer. For example, you might use 192.168.0.10.
   • Ensure the subnet mask is set to 255.255.255.0.
   • Save the settings.

4. Configure the Computer’s IP Address:

   • On your computer, go to the network settings.
     • Windows:
       1. Open Control Panel.
       2. Go to Network and Sharing Center.
       3. Click on Change adapter settings.
       4. Right-click on the Ethernet adapter connected to the printer and select Properties.
       5. Select Internet Protocol Version 4 (TCP/IPv4) and click Properties.
       6. Choose "Use the following IP address" and set the IP address to 192.168.0.20 (it should be different from the printer’s IP).
       7. Set the subnet mask to 255.255.255.0.
       8. Leave the Default Gateway and DNS fields blank.
       9. Click OK to save the settings.
     • Mac:
       1. Open System Preferences.
       2. Go to Network.
       3. Select Ethernet and click on Advanced.
       4. Go to the TCP/IP tab.
       5. Set Configure IPv4 to Manually.
       6. Enter 192.168.0.20 for the IP address and 255.255.255.0 for the subnet mask.
       7. Leave the Router field blank.
       8. Click OK and Apply to save the settings.

5. Add the Printer on the Computer:

   • Now, you need to add the printer on your computer.
     • Windows:
       1. Go to Control Panel.
       2. Select Devices and Printers.
       3. Click on Add a printer.
       4. Choose "Add a local printer or network printer with manual settings".
       5. Select "Create a new port" and choose Standard TCP/IP Port.
       6. Enter the printer’s IP address (192.168.0.10).
       7. Follow the prompts to install the printer driver (you may need the printer driver software from Toshiba's website).
     • Mac:
       1. Open System Preferences.
       2. Go to Printers & Scanners.
       3. Click the plus (+) button to add a printer.
       4. Select the IP tab.
       5. Enter the printer’s IP address (192.168.0.10).
       6. Choose the appropriate protocol (typically HP Jetdirect - Socket).
       7. Enter a name for the printer and select the appropriate driver.
       8. Click Add.

After completing these steps, your Toshiba e-STUDIO 2829A printer should be set up to print using a LAN cable directly connected to your computer without a router

PHP releases

 https://www.apachelounge.com/viewtopic.php?t=6359

https://windows.php.net/downloads/releases/

How to install SSL on CWP hostname?

1 - Check that you should have an A record for the hostname. For example if your server hostname is cp.hostinpk.com, then you should have an A record for "cp" pointing to server IP

2 - Login to CWP Admin Panel>> Server Settings>>Change Hostname and then hit "Change Hostname" button after putting your desired hostname (in my case cp.hostinpk.com). This will only generate a valid LE SSL for your hostname when an A record is present against hostname

3 - Perform following command from shell

service cwpsrv reload

How to merge a branch to main branch in Github.

In Terminal or Command Prompt: 

git checkout main [switch to main branch]

git pull origin main [grab latest updates from main branch]

git merge master merge [master branch to your main branch]

git push origin main [push your changes to main]

Extract Domain from email in Excel or Google sheet

 =TEXTAFTER(A2, "@")

or,

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