Number of input and output field

Number of input field	:	One
Number of output field	:	One

This transformation function is used to replace the content of a text field based on a database reference. The parameters of this transformation function are:

• JDBC Driver
  The JDBC driver class.
• JDBC URL
  The JDBC connection URL.
• User Name
  The database user name.
• Password
  The password of the database user.
• Table Name
  The name of the reference table.
• Target Field
  The field whose content will be compared against the incoming data.
• Replacement Filed
  The field whose content will be used to replace the incoming data.
• Number of Target
  Indicates the maximum number of replacements to perform.
• Target Position
  Specifies where the text to be replaced can appear (Start of Text, End of Text, or Any Position).
• Replacement Method
  Specifies whether to replace the First Occurrence or All Occurrences.

Example

Incoming Data

 A A HANIF A A
 A. A. GD. AFIF

Content of the reference table (for example, a table named 'name' consisting of the fields code and description):

Code        Description
A A         ANAK AGUNG
A A B       ANAK AGUNG BAGUS
A A NGR     ANAK AGUNG NGURAH
A A SG      ANAK AGUNG SAGUNG
A, A,       ANAK AGUNG
A. A        ANAK AGUNG
A. A .GDE   ANAK AGUNG GEDE
A. A.       ANAK AGUNG
A. A. B     ANAK AGUNG BAGUS
A. A. B.    ANAK AGUNG BAGUS
A. A. GD.   ANAK AGUNG GEDE

Function Parameters:

• Table Name = name
• Target Field = Code
• Replacement Field = Description
• Number of Target = 1
• Target Position = Any
• Replacement Method = First Occurrence

Output:

ANAK AGUNG HANIF A A
ANAK AGUNG GEDE AFIF