Data Resource Integration: Understanding and Resolving a Disparate Data Resource > Sub-stringing

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

Data Resource Integration: Understanding and Resolving a Disparate Data Resource

Search

Ch. 1. TOWARD A COMPARATE DATA RESOURCE

Ch. 2. DATA RESOURCE INTEGRATION CONCEPT

Ch. 3. INTEGRATING THE DATA RESOURCE

Ch. 4. DISPARATE DATA VARIABILITY

Ch. 5. DATA INVENTORY CONCEPT

Ch. 6. DATA INVENTORY PROCESS

Ch. 7. DATA CROSS-REFERENCING CONCEPT

Ch. 8. DATA CROSS-REFERENCING PROCESS

Ch. 9. PREFERRED DATA ARCHITECTURE CONCEPT

Ch. 10. PREFERRED DATA ARCHITECTURE PROCESS

Ch. 11. DATA TRANSFORMATION CONCEPT

Ch. 12. DATA TRANSFORMATION PROCESS

Ch. 13. INTEGRATING THE DATA CULTURE

Ch. 14. MANAGING THE DATA RESOURCE

Appx. A. DATA INTEGRITY RULE EXAMPLES

Data Integrity Rule Symbols

Data Integrity Rule Common Words

Data Value Rules

Conditional Data Value Rules

Data Structure Rules

Conditional Data Structure Rules

Data Derivation and Data Rederivation Rules

Data Retention Rules

Data Selection Rules

Data Translation Rules

Inheritance

Versions

Failure and Notification

Data Reconstruction Rules

Data Recast Rules

Appx. B. DATA HIERARCHY NOTATION

Appx. C. AGGREGATED DATA

GLOSSARY

BIBLIOGRAPHY

Index

Sub-stringing

Sub-stringing uses the back slashes with the ranges of the sub-stringing outside the back slashes and the data attribute inside the back slashes. In the example below, the vehicle's manufactured date is obtained by sub-stringing fields 5 through 8 from the vehicle comment data attribute.

Vehicle. Year Manufactured = 5 \ Vehicle. Comment \ 8

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial