Home » Categories » Solutions by Business Process » System Features |
Data Interchange - Import Large Text Strings |
Article Number: 1932 | Rating: Unrated | Last Updated: Tue, Jun 20, 2023 at 5:58 PM
|
Datafile Software Data Interchange - Import Large Text Strings The maximum data item size for text within Datafile is
64-characters which requires, if importing large text strings, pre-processing
outside of Datafile to split the text into constituent parts. This new feature allows Datafile to perform
this processing splitting the text items into separate items based on the size
of the item and to ‘intelligently’ split string of text based on spaces within
the text string. When cross-matching the data items if you reference
the same CSV column number item against consecutive data items you will be
prompted ‘Is this an overflow from the
previous data item’ for you to respond as required. Note To split text over a series of data items they must be equal in size and consecutive within the database. Text split is based on the item size and then works backwards to find the last space character (unless next character is a space) and updates the data item with this text with the remaining text being apportioned in a similar manner over the remaining block items.If no space is found within the number of characters of the item size then split will be based on item size. |
Attachments
![]() There are no attachments for this article.
|
Landing Grids
Viewed 1668 times since Mon, Jun 26, 2017
Datafile Software - Hardware and Software Supported Versions
Viewed 13746 times since Thu, Dec 13, 2012
Data Interchange Omit First Row from Import
Viewed 2078 times since Fri, May 27, 2016
Pick Lists - Increased No of Display Items
Viewed 2360 times since Wed, Sep 21, 2016
User-Definable Ledger Enquiry Applications
Viewed 21868 times since Tue, Jun 12, 2012
ASCII Import with Line Feed Only Record Delimiter
Viewed 4327 times since Wed, Jun 13, 2012
Ledger Enquiry - Additional CRM Categories
Viewed 4789 times since Fri, Jun 8, 2012
Database Table - Date Item Types - "F" Type Forecast Date Field
Viewed 2730 times since Fri, Mar 6, 2015
Label Printing
Viewed 1971 times since Wed, Jun 13, 2012
Documents to Email - Merge PDF Attachments
Viewed 2316 times since Mon, Jun 11, 2012
|