Split once - Delimited (floating) mode
Use the Split once with delimited (floating) mode to split text into two fragments, using a custom separator that is anywhere in the text. This is generally useful in files that do not contain CR, or LF characters, and you want to split the fragment into two, at some specific in-line location. Note the following:
•This mode creates two fragments defined by separator characters that you enter in the Separator field.
•The separator characters are not included in the fragment.
•The first fragment is defined as the text between the first character of the file/fragment, up to the last character before the separator.
•The second fragment is defined as the first character after the separator, up to the last character in the file/fragment.
•If the separator appears in the first/last position of the file/fragment, then the first of the two resulting containers remains empty.
The settings applicable to the Split once with delimited (floating) mode are listed below.
Regular expression
This is an optional setting which splits text into two fragments when there is a regular expression match (see Splitting Text with Regular Expressions ). The default value is "no".
Separator
Specifies the character(s) to be used as separator. The default value is "none" (no separator).
Split base
Head | Look for the first occurrence of the separator starting from the beginning of text. |
Tail | Look for the first occurrence of the separator starting from the end of text. |