General stuff#

Regular expressions (regex)#

see User Guide & Examples

Documentation#

Putting code or XML to word (Syntax highlighting)#

To insert nice highlighted text into word you use SciTE and follow this guide http://www.fauskes.net/nb/syntaxms/.

For Java see here.

Excel to CSV and vice versa#

Excel to CSV#

1. Open any XLSx file in Excel
2. Remove new lines inside cells
   1. Ctrl+H (Replace)
   2. Search for Ctrl+J or Alt+0+1+0 (use numpad for digits!)
   3. Replace All
3. Optional: Replace separator
   1. In the German version the separator is not a comma, but a semicolon. If you split by semicolon later and your tool is not considering the " you need to make sure that an inside semcolon is not used as cell separator
   2. Crtl+H (Replace)
   3. Search for ;
   4. Replace All
4. "Save As" > file type "CSV" (Note: first one, not MS-DOS/Macintosh)

CSV to Excel#

You can open csv files in Excel if they use the separator associated with your country version. In Germany this is a separator. If you have a "real" comma separated file, Excel will not split the content into cells.

1. Rename .csv file into .txt
2. Open Excel > Open file > choose your txt file
3. An open file wizard will let you choose encoding and separator then