String find at record beginning

Filter:

STRFIND

Syntax:

STRFIND expression

Operands:


expression :: string | hexstring
string :: delimiter character_string delimiter
hexstring :: X||*hex_code | H||*hex_code
binarystring :: B||*binary_code
hex_code :: any valid hexadecimal code string
binary_code :: 0 | 1
delimiter :: any character not used in the locate string

Functional Description:

Use the STRFIND stage to select all records containing a specified string at record beginning determined by an expression. The expression can be a character string or hexadecimal or binary string.

All records that contain the string or strings determined by the expression are written to the primary output stream in the order found in the input stream.

If the secondary output stream is connected, this filter writes all the records that do not contain the string by the expression to its secondary output stream. If the secondary output stream is not connected, this filter discards these records .

When STRFIND is used to search for a string, uppercase and lowercase representations of the same characters do not match. A match is found only if the data in the input records matches the target string you specify, including blank characters. Blank characters contained in the input stream must match the blank characters specified in the target string.

Hhexstring and Xhexstring:
defines a target string of hexadecimal characters, following the X or H, that defines a target string of characters to be located. The X or H can be specified in uppercase or lowercase. You must not specify any spaces in the string. There must be an even number of hexadecimal characters in the string.

negative locations on column range is not supported.

Secondary Input/Output:

OUTPUT

Synonyms:

None

Usage Notes:

The following example will find all occurences of ABC in beginning record columns

| STRFIND /ABC/ |



JAVA Pipelines

Cullen Programming logo