Home » Categories » Solutions by Business Process » System Features

Sub-Items Break on Character

Datafile Software

Sub-Items Break on Character

Sub-Items allow you to break an existing data item into smaller parts – for example taking the first three-characters of an account code. The sub-item is defined by selecting the data item it is based upon followed by setting the start position to split the text and the size. This new option allows you to define a sub-item so that a text item is split based on a character rather than setting a specific start and size position.

As an example an email address is made up of two parts split by the ‘@’ sign but the ‘@’ is in a random position so you cannot split the two parts using the existing sub-item options but the new option allows this.

Installation

When defining a sub-item you enter the data item label as required, select the item type as ‘=’, and then specify the data item you wish to base the sub-item upon (<F4-Select> is available if required). Remember that the sub-item must be after the base item within the file structure.

Next you are asked for the start position. At this point you can enter the start position within the item as previously – position 1, 15, etc. Alternatively you can enter the delimiter for which you wish to split the item upon – the delimiter can be any character apart from the numbers 0-9 or a space.

Finally you are asked for the size. If you entered a start position rather than a delimiter then the size is the number of characters on from the start position you wish to include in the sub-item. If you entered a delimiter then you are asked for a value from 1-9 corresponding to the split portion you require. In the example of the email address ‘1’ would be the first part before the ‘@’, and ‘2’ would be the second part after the ‘@’. However, if the delimiter character appears more than once you may want the third or fourth part, and so on. The delimiter can appear up to eight times within the base item which can therefore be split into a maximum nine parts. Note that if using the ‘delimiter’ option the size assigned to the sub-item is equal to that of the base item (if no delimiter then the full content of the field would be in the first partition).

Custom Fields
  • Release ID: 5.8
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Additional Forecast Date Options
Viewed 2529 times since Mon, Jun 11, 2012
General System Options - Email Address Format Validation
Viewed 149 times since Thu, Oct 17, 2024
Ledger Enquiry - Sales and Purchase Invoice Documents
Viewed 158 times since Tue, Oct 15, 2024
Scanned Documents - Save As PDF
Viewed 2436 times since Mon, Jun 11, 2012
Data Interchange - Import Large Text Strings
Viewed 2171 times since Fri, Oct 26, 2012
Application Reports - Save PDF Copy to Folder
Viewed 1877 times since Mon, Nov 25, 2013
Display Menu Name on Right-Click Configure
Viewed 1899 times since Wed, Jun 13, 2012
Emails in HTML Format (Outlook 2007)
Viewed 4379 times since Mon, Jun 11, 2012
Ledger Enquiry - Increased No of Stock Location Pick Items
Viewed 128 times since Thu, Oct 17, 2024