Editing filter functions edit the data in the current blob area; for example, adding data or eliminating data or extra spaces. With some of the filter functions in this category, you can use octal escape sequences or ASCII characters. When using octal escape sequences in a filter’s arguments, use “\NUL” instead of “\000” to indicate a null value.
Adds the data in the argument string (for example, add literals, or punctuation values to an existing field or component) to the end of the current blob area.
The text you want to add to the blob area;
for example, “M.D.”.
Removes all data from the current blob area that follows a specific character as identified by the value in the argument, and also removes the specified character. Adjusts its internal information to the new shorter length value. This function works from left to right in the blob area and stops when it reaches the first occurrence of the specified character.
The character that delimits the field; for example, “ (quote)
or \ (backslash) or , (comma).
Inserts a character into an output blob area at the specified location and for the length given.
OOO,LLL,X
where “OOO” is offset
in current blob area; “LLL” is
the length of the data to insert; and “X” is
character to insert (optional); for example, “20,10,q”.
The default is null (binary zero).
Replaces all characters in the current blob area that match the first character in the arguments field with the second character in the arguments field. You can also use octal escape sequences to specify a value.
The character you want replaced and its replacement.
An argument of “#$” causes
replacement of all “#” in
the blob area with “$”.
An argument of “\101\141” causes
replacement of all values that match “\101” with
the value “\141”.
Replaces the first occurrence of a character in the blob area that matches the first character in the arguments field with the second character in the arguments field. You can also use octal escape sequences to specify a value.
The character you want the first occurrence of replaced, and its replacement.
An argument of “@*” causes
replacement of the first occurrence of “@” with “*”.
Replaces the last occurrence of a character in the blob area that matches the first character in the arguments field with the second character in the arguments field. You can also use octal escape sequences to specify a value.
The character you want the last occurrence of replaced, and its replacement.
An argument of “^|” causes
replacement of the last occurrence of “^” with“|”.
Replaces all leading characters in the current blob area that match the first character in the arguments field with the second character in the arguments field. You can also use octal escape sequences to specify a value.
The character you want replaced, and its replacement.
An argument of “#$” causes
replacement of leading “#” with “$”.
Replaces all trailing characters specified in the arguments from the current blob area. You can also use octal escape sequences to specify a value.
The character you want replaced, and its replacement.
An argument of “#$” causes
replacement of trailing “#” with “$”.
An argument of “\NUL\003” causes
replacement of trailing”\000” with “\003”.
Replaces the characters specified in the arguments from the current blob area. You can use octal escape sequences to specify a value.
Search pattern | replacement pattern.
An argument of “\012123|A\010BC” causes
replacement of all “<FORM FEED>123” with “A<LINE
FEED>BC”.
Removes part of the current output blob area at the specified location (offset) and for the given length.
OOO,LLL
where “OOO” is the offset in current blob area; “LLL” is the length to cut with a maximum of 32767. To cut to end of blob, use the maximum value.
012,003 specifies that
at offset position 12, remove 3 characters.
Inserts a string into the current blob area following the first occurrence of the specified character. You can also use octal escape sequences for the specified character. Use a comma or a pipe to separate the arguments.
character, string
where “character” is the character after which to insert the string, and “string” is the data to insert.
$,new data specifies
that after the first $,
insert “new data”.
Inserts a string into the current blob area at the specified offset location (optional). If you do not specify an offset, the filter inserts the string at the beginning of the blob area. When not using an offset, the string must start with an alphabetic character. Use a comma to separate the arguments.
offset,string
where “offset” is the location to insert the string, starting from zero (0), and
“string” is the data to insert.
“25,123ABC” specifies
that at offset position “25”,
insert “123ABC”.
“ABC123” specifies
to insert “ABC123” at
the beginning of the current blob area (position
0).
“0,123ABC” specifies
to insert “123ABC” at
the beginning of the current blob area (position
0).
Inserts a string into the current blob area following the first occurrence of the specified pattern. Use a comma or a pipe to separate the arguments. The pattern cannot contain a comma or a pipe; the filter treats it as the argument “separator.”
pattern,string
where “pattern” is the pattern after which to insert the string, and “string” is the data to insert.
^^^^,new
data specifies that after the first occurrence
of “^^^^”,
insert “new data”.
“put here|new
data” specifies that after the first
occurrence of “put here”,
insert “new data”.
Removes the characters listed in the arguments from the current blob area. You cannot use octal escape sequences to specify a value.
The characters you want removed.
An argument of “#” causes
removal of all “#” from
the blob area.
An argument of “and” causes
removal of all “a”, “n”,
and “d” characters.
Removes the character specified in the arguments from the current blob area. You can also use octal escape sequences to specify a value.
The character you want removed.
An argument of “#” causes
removal of all “#” from
the blob area.
An argument of “\003” causes
removal of all “\003” values
from the blob area.
Removes the first occurrence of the character specified in the arguments from the current blob area. You can also use octal escape sequences to specify a value.
The character that you want the first occurrence of removed.
An argument of “@” causes
removal of the first occurrence of “@” from
the blob area.
Removes the last occurrence of the character specified in the arguments from the current blob area. You can also use octal escape sequences to specify a value.
The character that you want the last occurrence of removed.
An argument of “&” causes
removal of the first occurrence of “&” from
the blob area.
Removes all leading characters specified in args from the current blob area. You can also use octal escape sequences to specify a value.
None.
An argument of “#” causes
removal of leading “#” from
the blob area.
Removes all leading spaces from the current blob area.
None.
Removes the sequence of characters specified in the arguments from the current blob area. You cannot use octal escape sequences to specify a value.
The pattern of characters you want removed.
An argument of “123ABC” causes
removal of all “123ABC” from
the blob area.
Removes the range of characters specified in the arguments from the current blob area. You can also use octal escape sequences to specify a value.
The beginning and end of the range of characters that you want removed.
An argument of “az” causes
removal of all characters from “a” to “z” inclusive.
An argument of “\133\177” causes
removal of all characters from “[“ to hexadecimal “7F” inclusive.
Removes all spaces from the current blob area.
None.
Removes all trailing characters specified in the arguments field from the current blob area. You can also use octal escape sequences to specify a value.
The character you want removed.
An argument of “#” causes
removal of all trailing “#” values.
An argument of “\003” causes
removal of a trailing octal values that match “\003”.
Removes all trailing spaces from the current blob area.
None.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
