Posts filed under ‘IT/Soft’
Excel – Search for a character from the right
I want to extract “12C2” in string “D_CI-CC____-MY-12C2”
(1) Find position of “-” from the right: MATCH(“-“,INDEX(MID(A1,LEN(A1)-ROW(INDIRECT(“1:”&LEN(A1)))+1,1),0),0)
(2) Extract “12C2”: =RIGHT(A1, MATCH(“-“,INDEX(MID(A1,LEN(A1)-ROW(INDIRECT(“1:”&LEN(A1)))+1,1),0),0)-1)
Notepad++ Compare Plug-in
Click to download >> Rename .JGP to .ZIP
Export Google Calendar to Excel (free tool)
- Open http://www.gcal2excel.com/
- Grant access & Download
Change wi-fi display name and password (ASUS RT-N56U router)
1. Get IP of router’s admin interface (cmd –> ipconfig –> look at “Default Gateway” IP)
2. Type IP in web browser. For ASUS router:
- IP: 192.168.1.1
- username: admin
- password: admin
3. Go to “Wireless” panel, change SSID (username) and WPA Pre-Shared Key (wi-fi password)
4. Save/Apply
[VBS] Count number of rows in text file
‘copied from internet
Note: No blank lines between lines
Set FSO = CreateObject(“Scripting.FileSystemObject”)
Set file = FSO.OpenTextFile(“C:\Documents and Settings\a5105628\Desktop\ITSR44952_aug11.txt”, 1)
file.ReadAll
‘subtract one ReadAll stops at the first blank line
msgbox (file.line)-1