Changes between Initial Version and Version 1 of Ticket #525, comment 8


Ignore:
Timestamp:
Feb 9, 2016, 8:46:07 AM (9 years ago)
Author:
olle

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #525, comment 8

    initial v1  
    22
    33 1. Open INCA export file *.xlsx in !OpenOffice.org Calc.
    4  2. Replace all tab characters by empty strings:[[BR]]a. Menu "Edit" -> "Select All".[[BR]]b. Menu "Edit" -> "Find & Replace...".[[BR]]d. Click button "More Options", select "Regular expressions" in opened sub-window, in order to allow special characters to be represented with escape character "\".[[BR]]e. Search for `\t`.[[BR]]f. Replace with "" (blank field).[[BR]]g. Click button "Replace All".[[BR]]h. Close "Find & Replace" dialog.
    5  3. Replace all newline characters by empty strings:[[BR]]a. Menu "Edit" -> "Select All".[[BR]]b. Menu "Edit" -> "Find & Replace...".[[BR]]d. Click button "More Options", select "Regular expressions" in opened sub-window, in order to allow special characters to be represented with escape character "\".[[BR]]e. Search for `\n`.[[BR]]f. Replace with "" (blank field).[[BR]]g. Click button "Replace All".[[BR]]h. Close "Find & Replace" dialog.
     4 2. Replace all tab characters by empty strings:[[BR]]a. Menu "Edit" -> "Select All".[[BR]]b. Menu "Edit" -> "Find & Replace...".[[BR]]c. Click button "More Options", select "Regular expressions" in opened sub-window, in order to allow special characters to be represented with escape character "\".[[BR]]d. Search for `\t`.[[BR]]e. Replace with "" (blank field).[[BR]]f. Click button "Replace All".[[BR]]g. Close "Find & Replace" dialog.
     5 3. Replace all newline characters by empty strings:[[BR]]a. Menu "Edit" -> "Select All".[[BR]]b. Menu "Edit" -> "Find & Replace...".[[BR]]c. Click button "More Options", select "Regular expressions" in opened sub-window, in order to allow special characters to be represented with escape character "\".[[BR]]d. Search for `\n`.[[BR]]e. Replace with "" (blank field).[[BR]]f. Click button "Replace All".[[BR]]g. Close "Find & Replace" dialog.
    66 4. Save edited file as *.csv file in tab-delimited format:[[BR]]a. Menu "File" -> "Save As...".[[BR]]b. In "Save As" dialog, select directory to save created file in.[[BR]]c. For "Save as type:" select "Text CSV (.csv) (*.csv)".[[BR]]d. For "File name:" change file extension to ".csv", if not already done by "Automatic file name extension".[[BR]]e. Click button "Save".[[BR]]f. In extra dialog, select "Keep Current Format" (not "Save in ODF Format").[[BR]]g. In "Export Text File" dialog, for "Character set" select "Unicode (URF-8)".[[BR]]h. In "Export Text File" dialog, for "Field delimiter" select "{Tab}".[[BR]]i. In "Export Text File" dialog, for "Text delimiter" select "" (blank field).[[BR]]j. In "Export Text File" dialog, select check box option "Save cell content as shown" (all other check box options unselected).[[BR]]k. In "Export Text File" dialog, click button "OK".