Table of Contents

Search

  1. Preface
  2. PowerExchange Navigator Introduction
  3. Data Maps
  4. Data Maps for Specific Data Sources
  5. Copybooks
  6. Registration Groups and Capture Registrations
  7. Extraction Groups and Extraction Maps
  8. Personal Metadata
  9. Database Row Test
  10. PowerExchange Navigator Examples
  11. Appendix A: PowerExchange Functions for User-Defined Fields
  12. Appendix B: User Access Method Programs
  13. Appendix C: Application Groups and Applications
  14. Appendix D: Data Map Properties
  15. Appendix E: Record, Field, and Table Properties
  16. Appendix F: DTL__CAPXTIMESTAMP Time Stamps
  17. Appendix G: Trace for Creating a Memory Map When Importing a COBOL Copybook

Navigator User Guide

Navigator User Guide

Split

Split

Gets the contents of a field from a specified start point for a specified length. You might use this function to get a single field from a group field.
The field to be split must be a similar data type as the target field For example, you cannot use the Split function to copy a field with a character data type to a target field with a numeric data type.
To create a subfield with a datatype of other than CHAR from a CHAR source field, use the Split function in conjunction with the CopyData function, as follows:
  1. Use the Split function on the source field to create a new CHAR field.
  2. Use the CopyData function on the new CHAR field to create a target field with a different datatype, such as a numeric datatype.
Syntax:
result
=Split(
field
,
start_byte
,
length
)
The following table describes the parameters:
Parameter
Description
Datatype
result
Returns the contents of the field from the specified start byte for the specified length.
Any type
field
Field from which to get a subfield.
Any type
start_byte
The number of the byte where the subfield begins. Offsets begin at 1.
NUM32
length
The number of bytes to get.
NUM32

0 COMMENTS

We’d like to hear from you!