User contributions for Planetoid

18 April 2015

• 11:0611:06, 18 April 2015 diff hist −17 m Template:Code No edit summary
• 11:0411:04, 18 April 2015 diff hist +1 m Template:Code No edit summary
• 11:0411:04, 18 April 2015 diff hist +316 N Template:Code Created page with "* Keyboard key Style from http://support.mozilla.com/kb/Shortcuts <onlyinclude><span class="kbd" style=" padding: 0 1px; background: #faf6f6; color: #000; border:..."

17 April 2015

• 18:0118:01, 17 April 2015 diff hist +293 N Split text by symbol Created page with "Split text by symbol (delimiter / separator) Approachs * Excel: (1) LEFT, RIGHT, FIND, LEN (2) MOD, FIND, LEN * PHP: explode * MySQL: [http://www.w3resource.com/mysql/string-..."
• 16:4616:46, 17 April 2015 diff hist +32 PHP microtime to MySQL timestamp No edit summary
• 16:4616:46, 17 April 2015 diff hist +1,131 N PHP microtime to MySQL timestamp Created page with "{{exclaim}} Lose the accuracy after conversion. Microtime ex: 1426299057.8639 will lost the numeric after point (.8639) after saved to {{kbd | key = TIMESTAMP}} type ex: 2015-..."
• 16:4616:46, 17 April 2015 diff hist −1,031 PHP and MySQL syntax →PHP microtime to MySQL timestamp
• 16:4416:44, 17 April 2015 diff hist −63 PHP and MySQL syntax →date format
• 16:4416:44, 17 April 2015 diff hist +419 PHP and MySQL syntax →Query by month
• 05:5105:51, 17 April 2015 diff hist +1 m Excel replace na and 0 with empty No edit summary
• 05:5005:50, 17 April 2015 diff hist +454 Excel replace na and 0 with empty +color

16 April 2015

• 15:4115:41, 16 April 2015 diff hist +414 Excel replace na and 0 with empty No edit summary
• 11:3911:39, 16 April 2015 diff hist +109 Batch remove PHP short tags No edit summary
• 11:3711:37, 16 April 2015 diff hist +19 Data cleaning →references
• 11:3711:37, 16 April 2015 diff hist +20 Google Docs and Spreadsheets →references
• 11:3611:36, 16 April 2015 diff hist +19 Excel replace na and 0 with empty No edit summary
• 10:0710:07, 16 April 2015 diff hist +470 N Excel replace na and 0 with empty Created page with "replace #N/A and 0 with empty when vlookup 1. replace 0 with empty <pre> =IF( logical_test, [value_if_true], [value_if_false] ) =IF( VLOOKUP(A1,SHEET1!A:E,3,0) = 0..."
• 09:4009:40, 16 April 2015 diff hist +60 Open Source Community →前端技術(ex: Javascript)
• 01:0901:09, 16 April 2015 diff hist +126 Windows keyboard equivalents on Mac →text editing

15 April 2015

• 17:3317:33, 15 April 2015 diff hist +5 Batch remove PHP short tags No edit summary
• 17:3217:32, 15 April 2015 diff hist +660 N Batch remove PHP short tags Created page with "Using Regular expression to batch remove PHP short tags Target: * Before: {{kbd | key = <nowiki><?</nowiki>}} * After: {{kbd | key = <nowiki><?php</nowiki>}} case1: PHP..."

13 April 2015

• 11:5311:53, 13 April 2015 diff hist 0 m How to choose open source solution →延伸閱讀
• 11:4911:49, 13 April 2015 diff hist +404 How to choose open source solution →延伸閱讀
• 11:2811:28, 13 April 2015 diff hist +82 ASCII art No edit summary
• 10:0010:00, 13 April 2015 diff hist +1,630 System Check →緊急修復步驟

11 April 2015

• 16:2716:27, 11 April 2015 diff hist +261 Web Ping →分析網頁連線下載速度，並提供網站開發者建議的服務或軟體

9 April 2015

• 10:1710:17, 9 April 2015 diff hist +150 Category:Web server software →list of Web server software

8 April 2015

• 09:5209:52, 8 April 2015 diff hist +130 Web Ping →檢查網站是否被中國的防火長城(GFW, Great Firewall of China)封鎖

7 April 2015

• 14:4714:47, 7 April 2015 diff hist +57 Data cleaning →case: Number precision of Excel
• 14:4214:42, 7 April 2015 diff hist +5 m Data cleaning →case: Number precision of Excel
• 14:4214:42, 7 April 2015 diff hist −1 m Data cleaning →case: email: contains @ symbol
• 14:2214:22, 7 April 2015 diff hist +39 Data cleaning →case: Number precision of Excel
• 14:0614:06, 7 April 2015 diff hist +559 Data cleaning →verify the format of field value
• 14:0314:03, 7 April 2015 diff hist +17 m Data cleaning →verify the format of field value
• 14:0314:03, 7 April 2015 diff hist +1 m Data cleaning →check if field value was not fulfilled: NULL, empty value
• 14:0214:02, 7 April 2015 diff hist +52 Data cleaning No edit summary

5 April 2015

• 13:1113:11, 5 April 2015 diff hist 0 m Regular expression →快速查表
• 12:1312:13, 5 April 2015 diff hist 0 m Regular expression →快速查表
• 11:1811:18, 5 April 2015 diff hist +65 Tip on inviting speaker →活動初期
• 09:5809:58, 5 April 2015 diff hist +20 Regular expression →替代方案
• 04:1104:11, 5 April 2015 diff hist +31 Regular expression →快速查表
• 04:1004:10, 5 April 2015 diff hist +50 m Regular expression →快速查表
• 04:1004:10, 5 April 2015 diff hist +4 Regular expression →快速查表
• 03:5703:57, 5 April 2015 diff hist +171 Regular expression →快速查表
• 03:4603:46, 5 April 2015 diff hist +1,347 Regular expression →快速查表

4 April 2015

• 16:3116:31, 4 April 2015 diff hist +23 Regular expression →Regular expression online tools
• 16:2616:26, 4 April 2015 diff hist +69 Regular expression →快速查表
• 16:1416:14, 4 April 2015 diff hist +93 m Regular expression →Regular expression online tools

2 April 2015

• 16:2116:21, 2 April 2015 diff hist +7 m Regular expression →快速查表
• 15:5415:54, 2 April 2015 diff hist +3 m Regular expression →快速查表