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)

4 May, 2016 at 9:49 am Leave a comment

Notepad++ Compare Plug-in

ComparePlugin.v1.5.6.2.bin

Click to download >> Rename .JGP to .ZIP

17 February, 2015 at 8:54 am Leave a comment

Export Google Calendar to Excel (free tool)

  1. Open http://www.gcal2excel.com/
  2. Grant access & Download

17 August, 2014 at 4:41 am Leave a comment

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

1 June, 2014 at 3:37 pm Leave a comment

[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

4 October, 2011 at 10:55 am Leave a comment

[vb] Merge several excel files into 1 separate worksheet

VB code from here

Googledoc backup just in case

Thank you experts ~.~

6 May, 2011 at 11:13 am Leave a comment

[vbs] Get folder names / file names in a directory

‘Option explicit

Set fs = CreateObject(“Scripting.FileSystemObject”)

‘create output file
Set outFile = fs.CreateTextFile(“d:\folder_name.txt”)

‘set directory
Set oFolder = fs.GetFolder(“d:\”)

‘if get file name use this
‘Set oFiles = oFolder.Files

‘if get folder name use this
Set oSubFolder = oFolder.SubFolders

‘go through list
For Each i In oSubFolder

‘write to output
outFile.writeline i.Name

Next

WScript.Echo “Finish!”

18 February, 2011 at 5:46 pm Leave a comment

Older Posts


October 2017
M T W T F S S
« Sep    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Categories