GeeDee for Windows

CSV Exports Single Column

CSV Exports Single Column

Previous topic Next topic No directory for this topic Expand/collapse all hidden text  

CSV Exports Single Column

Previous topic Next topic Topic directory requires JavaScript JavaScript is required for expanding text JavaScript is required for the print function Mail us feedback on this topic!  

Basic information on changing GeeDee CSV exports to single column with MS Excel.

 

clip0077
 

Click me to expand / collapse information.Steps by image and brief description

 
clip0080
Open Excel.
 
 
clip0085
Copy column from your GeeDee's CSV into notepad.

 

clip0081
Paste into a clean separate sheet in Excel using a Right Click in column A. Select the "A" Paste Options, choosing "Keep Text Only (T)".

 

clip0082

When you select the "A" Paste Options choosing "Keep Text Only (T)", additional Paste Options appear at the bottom, Click and select the "Use Text Import Wizard...".
 
 
clip0083
Choose Delimiters "Space".

Select Finish.

Copy and paste into original database sheet or desired location...

 


 
Libre Office
 

1.) Opens List and presses the <CTRL> and the <A> keys at the same time.
2.) Goes to menu and opens Libre Office Calc.
3.) Selects a cell, any cell, and presses <Control> and <V> at the same time.
4.) Views the "language" dialogue box, and accepts the default of Automatic.
5.) If your "any cell" was A1, select columns A to D, then select <Format> -> <Merge Cells> -> <Split Cells>.
6.) With columns A to D still highlighted, Select <Data>, <sort> then choose to sort on column C in ascending or descending order if you want price, column A if you want alphabetical order, column B if you want original price or column D if you want to get the biggest discount regardless of what crap you order.

 

 

 

GeeDee Company Logo_Horizontal_MEDIUM
Phone: (08) 9364 6677  | Fax: (08) 9364 7433   | eMail: info@geedee.com.au   | Web: http://www.geedee.com.au/

© GeeDee for Windows Pty Ltd  1984 - 2018             All rights reserved.      Real Estate Software by Real Estate Professionals.

Trust Accounting & Property Management Software with Enterprise Electronic Document Management.