2012年12月21日

notepad++过滤重复行

摘要: 先安装TextFx插件The check boxes and buttons required to do this are located in the menu under: TextFX-->TextFX ToolsMake sure "sort outputs only unique..." is checked. Then select a block of text (ctrl-a to select the entire document). Then click "sort lines case sensitive" or &quo 阅读全文

posted @ 2012-12-21 15:53 haven24 阅读(12473) 评论(0) 推荐(0) 编辑

excel提取主域名

摘要: =IF(LEFT(LEFT(SUBSTITUTE(A1,"http://",""),FIND("/",SUBSTITUTE(A1,"http://","")&"/")-1),4)="www.",MID(LEFT(SUBSTITUTE(A1,"http://",""),FIND("/",SUBSTITUTE(A1,"http://","")&& 阅读全文

posted @ 2012-12-21 15:02 haven24 阅读(2434) 评论(0) 推荐(0) 编辑

导航