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
Select Enquiry
Viewed 2102 times since Tue, Jun 12, 2012
Display Price Item Names
Viewed 2365 times since Fri, May 20, 2016
Document Design Manager - Additional Notes
Viewed 2600 times since Wed, Jun 13, 2012
Customer / Product History Enquiry
Viewed 4556 times since Tue, Jun 12, 2012
Scanned Documents - Save As PDF
Viewed 2594 times since Mon, Jun 11, 2012
Datafile Software - File Naming Conventions
Viewed 5207 times since Thu, Jul 26, 2012
Document Design Manager - Setting and Applying Font Defaults
Viewed 2346 times since Wed, Jun 13, 2012
Image Display on Maintenance Screens
Viewed 2480 times since Wed, Jun 13, 2012
Automatically Display Linked Files - Allow Items from Lookup Database in History/Details List - Link to BOM Detail Pick List
Viewed 2056 times since Fri, Jul 21, 2017