Text Sort

Text_generator  Text_merge 

Text Sort by word

Example:

Sort all line of text by the second word

Text sort

Replace procedures:

1. ctrl-o open source txt/csv file

2. ctrl-h open 'replace' window

1) Replace Unit=Chars

2) Search for pattern=.*

3) Replace with pattern=sort_by_word($match,2)

4. click 'replace', done!

Text Sort by date

Example:

Sort csv file by the date column B

Text sort

Replace Procedures:

1. ctrl-o open source txt/csv file

2. ctrl-h open 'replace' window

* set 'replace with pattern' to:

sort_by_word($match,2,2,'date')

3. click 'settings' tab, set 'input delimiter' and 'output delimiter' to 'other', and enter a single comma behind.(note: if text is seperated by space, just set input/output delimiter to 'space')

4. click 'replace', done!

5. if there are multiple files, click 'batch...' and drag multiple files to 'batch runner' window, and click 'batch replace' button.

Text Sort by self defined function

Example:

Sort text by the length of line

Text sort

Replace Procedures:

1. ctrl-o open source txt/csv file

2. ctrl-h open 'replace' window

* set 'replace with pattern' to:

sort_by_func($match,'length')

3. click 'replace', done!

Notes:

For batch replace files, please refer to Replace Pioneer help manual.


', '>',$fString); $fString = str_replace( '<', '<',$fString); $fString = str_replace( chr(32), ' ',$fString); $fString = str_replace( chr(13), ' ',$fString); $fString = str_replace( chr(10) & chr(10), '
',$fString); $fString = str_replace( chr(10), '
',$fString); } return $fString; } function show_pages($page,$MaxPage,$colname_rs) { echo " Page:$page/$MaxPage    "; if ($MaxPage<=1) {return;} echo "Goto: "; if ($page>1) { $prevPage=$page-1; echo "\"Previous  "; } for($p=$page-10;$p<=$page-1;$p++) { if ($p>0) { echo "$p ";} } echo "$page "; for($p=$page+1;$p<=$page+10;$p++) { if ($p<=$MaxPage) { echo "$p ";} } if ($page<$MaxPage) { $nextPage=$page+1; echo " \"Next "; } echo ""; } //$dbid = mysql_connect($hostname,$dbuser,$dbpasswd) or die(""); //mysql ServerNorthWind //$db = mysql_select_db("mindp9_test",$dbid) or die(""); //SQL $query = "SELECT * FROM ("; for($i=0;$i $MaxPage) $page=$maxPage; ?>

Other Examples of "" " .HtmlEncode($arr[2]).""; } //if }//for echo "
"; }//if ?> Search all "" examples