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


Ignore:
Timestamp:
Feb 9, 2016, 8:55:51 AM (8 years ago)
Author:
olle

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #525, comment 8

    v1 v2  
    44 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.
    55 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.
    6  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".
     6 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 (UTF-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".
     7 5. Close !OpenOffice.org Calc window.