String Functions in Ab Initio : Part 1

 Refer Below details for all the list of string function available in Ab Initio

char_string   

• It returns a one-character native string that corresponds to the specified character code.

decimal_lpad   

• It returns a decimal string of the specified length or longer, left-padded with a specified character as needed.

decimal_lrepad   

• It returns a decimal string of the specified length or longer, left-padded with a specified character as needed and trimmed of leading zeros.

decimal_strip   

• It returns a decimal from a string that has been trimmed of leading zeros and non-numeric characters.

edit_distance   

• It returns the minimum number of single-character insertions, deletions, and substitutions needed to turn a specified string into another.

ends_with

• It returns 1 (true) if a string ends with the specified suffix; 0 (false) otherwise.

from_json

• It returns a DML object from a JavaScript Object Notation (JSON) document.

from_xml   

• It returns a DML object from an Extensible Markup Language (XML) document.

hamming_distance   

• It returns the minimum number of single character substitutions needed to turn a specified string into another string.

is_blank   

• It tests whether a string contains only blank characters.

is_bzero   

• It tests whether an object is composed of all binary zero bytes.

make_byte_flags   

• It returns a vector of flags that indicates whether a character occurs in a specified string.

multistring_create   

• It returns a multistring handle from a vector of strings and creates its associated index.

multistring_find   

• It returns the first instance of a string matching a string element of a multistring vector.

multistring_find_all   

• It returns all instances of a string matching the string elements of a multistring vector.

multistring_free   

• It resets a multistring handle, removing its associated index and freeing its memory.

multistring_lfind   

• It returns the longest match to the string elements of a multistring vector at the beginning of a searchable string.

multistring_rfind   

• It returns the longest match to the string elements of a multistring vector at the end of a searchable string.

 

 

Ab Initio Component | NORMALIZE : Part 1

Purpose

•  NORMALIZE is used to generate multiple output records from each of its input records. You can directly specify the number of output records for each input record, or you can make the number of output records dependent on a calculation. 

• In contrast, to consolidate groups of related records into a single record with a vector field for each group — the inverse of NORMALIZE — you can use the accumulation function of the ROLLUP component.

 Parameters for NORMALIZE

Note : Only the important parameter are covered the uncovered parameters are the common parameters which is been covered in other components details

transform (filename or string, required)

• The name of the file containing the types and transform functions, or a transform string.

error_group (string, optional)

• This parameter defines name of the error group to which this component belongs. The component sends its error output to the HANDLE ERRORS component with a matching error_group value.

log_group (string, optional)

• This parameter defines name of the log group to which this component belongs. The component sends its log output to the HANDLE LOGS component with a matching log_group value.

reject-threshold (choice, optional)

•  The component’s tolerance for reject events
• This parameter defines after how many reject records the component processing is aborted.
  

 
log_intermediate (choice, optional)

• This parameter defines how often the component sends an intermediate record to its log port. Available only when the logging parameter is set to True.

• For example, if you select 50, the component sends every 50th intermediate record to its log port.

Transform package for NORMALIZE

• Mentioned below describe the functions, types, and variables available in the transform package for NORMALIZE:

•     Simple transform
•     Multistage transform
•     How many records to produce
•     Other optional transform functions