流水上面的一塊葉

Excel 只保留文內特定符號或文字後的字串 保留文內特定符號或文字 前 的字串 =LEFT(text,FIND(character,text)-1) or 保留文內特定符號或文字 後 的字串 =RIGHT(text,FIND(character,text)-1)  e.g. 文字B5, 特定符號"_" :  特定符號"_"  前 文字 =LEFT(B5,FIND("_",B5)-1) 特定符號"_" 後 文字 =RIGHT(B5,LEN(B5)-FIND("_",B5)) Reference: https://exceljet.net/formula/split-text-string-at-specific-character

如何在Windows server 2003 下擴展(擴增)磁碟分割區容量 \ How to use diskpart.exe command extend partition size on Windows server 2003 解決方法/Solution :   使用 Windows 本身內建的程式 diskpart.exe 此工具可讓您使用命令提示字元的指令來管理，磁碟、磁碟分割或磁碟區。 Run CMD to command prompt and then type following command: diskpart DISKPART> list disk  (list your disk number) DISKPART> select disk 1  ( "disk 1" is the number of disk you want to extend) DISKPART> list  partition  DISKPART> select partition 1 ( "partition 1" is the number of partition you want to extend) DISKPART> extend  DISKPART> exit p.s. extend command without any parameter will default extend the maximum available free space to use, if you not want use all the free space you can define the size with parameter "size={number}" i.e.  extand size=20000 After finish type "exit" enter to exit diskpart. Reference: 使用diskpart來擴增磁碟分割區容量(適用於2000,xp,win2003  https://blog.xuite.net/ganpin917/home/44007001-%E4%BD%BF%E7%94%A8diskpart%E4...

mysqlpump 免密碼備份 進入Mysql shell  輸入以下指令，跟著輸入密碼,就會 創建加密秘鑰。 root@localhost # mysql_config_editor  set --login-path=passkey --host=localhost --user=root --password 執行下面 備份 的 指令可以 不用輸入密碼 ，參數  "--login-path=passkey"  ，這個 “passkey” 參數 對應上面 創建的加密秘鑰 root@localhost # mysqlpump --login-path=passkey mydatabase > bak.sql  

Windows 10 Audio disabled (no sound and speaker volume icon show disable) problem 1.           In Device Manager from the menu. 2.           In Device Manager, expand Other Devices Intel High Definition Audio. 3.           Press View and then select Devices by connection. 4.           Expand ACPI x64-based PC. under              -   Microsoft ACPI-Compliant System                -   PCI Express Root Complex                   -   Intel(R) Smart Sound Technology (Intel(R) SST) Audio Controller  Select "Intel (R) Smart Sound Technology (Intel(R) SST)…" 5.           Right click mouse button and select Uninstall. à ...

解決windows 10 無法連線smb1 問題 (轉載) (轉載自) https://helloworld.pixnet.net/blog/post/46536909-%E8%A7%A3%E6%B1%BA-windows-10-%E7%84%A1%E6%B3%95%E9%80%A3%E7%B7%9A-smb1-%E5%95%8F%E9%A1%8C 出現以下的錯誤訊息: "因為檔案共用不安全，所以無法連線。此共用需要過時的 SMB1 通訊協定，而這個通訊協定既不安全，而且可能使您的系統容易受到攻擊 您的系統需要 SMB2 或是更高版本" 解決方式 在控制台中找到 "開啟或關閉 Windows 功能"  或是 windows 鍵 + R ，輸入 optionalfeatures 並執行 找到 SMB1 相關的選項，全部勾選，並重開機即可

Windows can't boot and get following error message  Windows XP could not start because the following file is missing or corrupt: \WINDOWS\SYSTEM32\CONFIG\SYSTEM Windows XP could not start because the following file is missing or corrupt: \WINDOWS\SYSTEM32\CONFIG\SOFTWARE Stop: c0000218 {Registry File Failure} The registry cannot load the hive (file): \SystemRoot\System32\Config\SOFTWARE or its log or alternate  System error: Lsass.exe When trying to update a password the return status indicates that the value provided as the current password is not correct. You can following method to restore windows registry Windows 7/Windows XP Method 1: Boot to  command prompt or Windows PE Rename following file: ren c:\windows\system32\config\system c:\windows\tmp\system.bak ren  c:\windows\system32\config\software c:\windows\tmp\software.bak ren  c:\windows\system32\config\sam c:\windows\tmp\sam.bak ren  c:\windows\system32\config\secur...

Windows 7 開不了機藍畫面的解決辦法 Windows 7 cannot boot show blue screen with error message "STOP 0x0000007B" Symptoms:  Cannot Boot to Windows(Auto reboot) show blue screen with following error message: (Blue screen with following error message)  STOP 0x0000007B INACCESSABLE_BOOT_DEVICE BSOD: 0x0000007b (0x80786B58, 0xC0000034, 0x00000000, 0x00000000) Solution: Use Windows PE bootdisk or remove hard disk and put to other PC  Edit following register key value from 3 to 0. HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Msahci HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\IastorV HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\iaStor In the pane on the right side, right-click  Start  in the  Name  column, and then click  Modify . In the  Value data  box, type  0 , and then click  OK . On the  File  menu, click  Exit  to close Registry Editor. How to access and edit another ha...