When using the Ledger Enquiry the option is available
within the Utilities panel to copy selected items to the Clipboard for pasting
into other applications – this is typically used to copy name and address
detail for posting into Word etc. When
copying the system uses a CR/LF character as the delimiter between the selected
items so that each entry is pasted on separate lines, occasionally, when
pasting to Excel for example, you may which to paste across the page. This new feature allows for the system to
optionally use <TAB> delimiters to separate the data facilitating pasting into Excel.
A tick box is available at the end of the clipboard list asking if you wish to use <TAB> delimiters – select as required. The setting is remembered within the action but will revert to default setting on exit from Ledger Enquiry or on swap to another application within the enquiry.
Installation
Database Changes
The option to select to use <TAB> delimiters is available immediately on program update but to set to use <TAB> delimiters by default requires a change in the INI file associated with each database – this INI file can be updated via the database restructure tools.
To
restructure the database Diamond and Premier users can select Installation from the main menu followed by Application Manager and then Restructure
A Database. Select the required application.
Elect to update the Live Files and then select the main application database. Professional users can restructure the database by accessing the Database Systems menu option followed by Datafile Database Utilities, Create/Amend
Database Structures and Restructure
A Database before entering the filename to change. The existing data items
are then displayed on screen but press <F4-Select> to access the advanced
features and choose the Database INI settings and then within the INI settings
select the COPY option to define the clipboard copy items and set the default
delimiter.
Once set click the OK button to accept the clipboard settings and click SAVE to accept the INI changes and you are returned to the data item list. At this point press <ESC> and choose UPDATE.
Article ID: 1929
Created On: Fri, Oct 26, 2012 at 11:59 AM
Last Updated On: Tue, Jun 20, 2023 at 5:59 PM
Online URL: https://kb.datafile.co.uk/article/copy-to-clipboard-use-tab-delimiter-1929.html