General stuff#

Regular expressions (regex)#

see User Guide & Examples


Putting code or XML to word (Syntax highlighting)#

To insert nice highlighted text into word you use SciTE and follow this guide

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

Add new attachment

Only authorized users are allowed to upload new attachments.
« This page (revision-) was last changed on 29-Sep-2018 19:57 by Administrator