Hello World

钉钉群联系导出整理公式&全称匹配简称lookup教程

钉钉群联系导出整理公式
群主	=MOD(ROW(A2),2)
皓渊	=MOD(ROW(A3),2)
杜渊	=MOD(ROW(A4),2)	LEFT(A4,SEARCH("-",A4)-1)	=LEFT(A4,SEARCH(" ",A4)-1)
苏毅	=MOD(ROW(A5),2)		=LEFT(A5,SEARCH(" ",A5)-1)

阅读全文

H3C-S5120

常用公式

阅读全文

清除运行记录

@echo off
color 0a
title 清除运行记录
echo Windows Registry Editor Version 5.00 >>pc.reg
echo [-HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\RunMRU] >>pc.reg
regedit /s pc.reg
del pc.reg
TASKKILL /f /IM explorer.exe
start %SystemRoot%\explorer.exe

阅读全文

批量删除文件名中字符

@echo off& setlocal enabledelayedexpansion
for /f "delims=" %%1 in ('dir /a /b') do (set wind=%%1
ren "%%~1" "!wind:*********=!")

阅读全文

mstsc记录清除

@echo off
reg delete "HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client\Default" /va /f
reg delete "HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client\Servers" /f
reg add "HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client\Servers"
cd %userprofile%\documents\
attrib Default.rdp -s -h
del Default.rdp

阅读全文