Data Cleansing Software
Search WinPure Website
 
 

Frequently Asked Questions (FAQ) - ListCleaner Pro

 

 

Exporting Files

 
 
 

Will the 'Export' overwrite my file?

Why can I only export just 20 records?

How does WinPure ListCleaner 'export' a Text file?

Is it possibly to import from Access, then export to different file formats?

Can export my ACT database to a different file and location?

Can I export back to Access 97?

The 'export' feature seems to be disabled, why is this?

How do I export just filtered selections?


Will the 'Export' overwrite my file?

If you would like it to. Basically you have the option of either exporting over the existing file (ie. the file you imported into WinPure ListCleaner), or exporting as a different filename of filetype. For example, you could import a text file called 'txtNames' and then export it as an Excel file called 'ExcelNames'.

 

Why can I only export just 20 records?

You are using the trial version, which only allow a maximum export of 20 records. Once you purchase the licence key, there will be no limitation.

 

How does WinPure ListCleaner 'export' a Text file?

WinPure ListCleaner will export text files as a coma delimited. A comma delimited text file is an industry standard. In this file format comma (,) is used as column separator (delimiter) and double quotation mark (") is used as text qualifier. You cannot change these settings i.e use other characters as column delimiter and text qualifier.

A simple example:
Data In WinPure ListCleaner::
Column1=John Smith
Column2=Merryl Steet
Column3=35

Exported in the text file:
"John Smith", "Merryl Steet", 35

A more complex example:
*** Notice how commas and double quotation marks are treated ***
Data In WinPure ListCleaner:
Column1=John Smith says "It's Fine"
Column2=Merryl Steet,Ohio,USA
Column3=35

Exported in the text file:
"John Smith says ""It's Fine""", "Merryl Steet,Ohio,USA", 35

 

Is it possibly to import from Access, then export to different file formats?

Yes, you can export to any of the formats that WinPure ListCleaner handles (currently Excel, Access, Text, ACT! & HTML)

 

Can export my ACT! database to a different file and location?

No, as ACT! databases contains many linked files that would also need to be copied over. As a precaution, WinPure ListCleaner will simply overwrite your existing database. We always recommend you make a backup before you overwrite any datafiles/databases.

 

Can I export back to Access 97?

Yes, as well as the many other formats WinPure ListCleaner currently uses.

 

The 'export' feature seems to be disabled, why is this?

You need to be on the 'DataTable' module, in order to export your files.

 

How do I export just filtered selections?

Once you have a filtered selection (when the Data Table turns yellow), simply select 'Export' and WinPure ListCleaner will ask you if you want to export the filtered selection only.

       
 
 
Data Cleansing & Dedupe Software Specialists. Copyright (c) 2002-2010 WinPure Ltd, All Rights Reserved - Site Map