What are the different String functions used in Abinitio?
- 3 Answers
- 53872 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aditya
There are numerous string functions like :
char_string
decimal_lpad
decimal_lrepad
decimal_strip
is_blank
re_replace
re_replace_first
string_char
string_compare
string_concat
string_filter
string_filter_out
string_join
string_length
string_lpad
string_lrepad
string_lrtrim
string_ltrim
string_pad
string_replace
string_replace_first
string_split
string_substring
string_to_hex
string_trim
and many more
| Is This Answer Correct ? | 24 Yes | 0 No |
Answer / hari
string_concat(?,?);
string-lpad();
string_rpad();
string_index();
string_rindex();
string_replase();
like that functions.
| Is This Answer Correct ? | 17 Yes | 1 No |
Answer / amansharma3737@gmail.com
char_string
Returns a one-character native string that corresponds to
the specified character code.
decimal_lpad
Returns a decimal string of the specified length or longer,
left-padded with a specified character as needed.
decimal_lrepad
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
Returns a decimal from a string that has been trimmed of
leading zeros and non-numeric characters.
ends_with
Returns 1 (true) if a string ends with the specified suffix;
0 (false) otherwise.
is_blank
Tests whether a string contains only blank characters.
is_bzero
Tests whether an object is composed of all binary zero bytes.
re_get_match
Returns the first string in a target string that matches a regular
expression.
re_get_matches
Returns a vector of substrings of a target string that match a regular
expression containing up to nine capturing groups.
re_index
Returns the index of the first character of a substring of a target
string that matches a specified regular expression.
re_match_replace
Replaces substrings of a target string that match a specified
regular expression.
re_replace
Replaces all substrings in a target string that match a specified regular
expression.
re_replace_first
Replaces the first substring in a target string that matches a specified
regular expression.
starts_with
Returns true if the string starts with the supplied prefix.
string_char
Returns the character code of a specific character in a string.
string_compare
Returns a number representing the result of comparing two strings.
string_concat
Concatenates multiple string arguments and returns a NUL-delimited string.
string_downcase
Returns a string with any uppercase letters converted to lowercase.
string_filter
Compares the contents of two strings and returns a string containing characters
that appear in both of them.
string_filter_out
Returns characters that appear in one string but not in another.
string_index
Returns the index of the first character of the first occurrence of a string within
another string.
string_is_alphabetic
Returns 1 if a specified string contains all alphabetic characters, or 0 otherwise.
string_is_numeric
Returns 1 if a specified string contains all numeric characters, or 0 otherwise.
string_join
Concatenates vector string elements into a single string.
string_length
Returns the number of characters in a string.
string_like
Tests whether a string matches a specified pattern.
string_lpad
Returns a string of a specified length, left-padded with a given character.
string_lrepad
Returns a string of a specified length, trimmed of leading and trailing blanks and
left-padded with a given character.
string_lrtrim
Returns a string trimmed of leading and trailing blank characters.
string_ltrim
Returns a string trimmed of leading blank characters.
string_pad
Returns a right-padded string.
string_prefix
Returns a substring that starts at the beginning of the parent string and is of the specified length.
string_repad
Returns a string of a specified length trimmed of any leading and trailing blank characters,
then right-padded with a given character.
string_replace
Returns a string after replacing one substring with another.
string_replace_first
Return+B14s a string after replacing the first occurrence of one substring with another.
string_rindex
Returns the index of the first character of the last occurrence of a string within another string.
string_split
Returns a vector consisting of substrings of a specified string.
string_split_no_empty
Behaves like string_split, but excludes empty strings from its output.
string_substring
Returns a substring of a string.
string_trim
Returns a string trimmed of trailing blank characters.
string_upcase
Returns a string with any lowercase letters converted to uppercase.
test_characters_all
Tests a string for the presence of ALL characters in another string.
test_characters_any
Tests a string for the presence of ANY characters in another string.
| Is This Answer Correct ? | 8 Yes | 1 No |
Hello, I need help on passing parameter to Oracle Stored Procedure.I am a oracle DBA,need to use some graphs. I need help to pass date parameter with format YYYYMMDD from Ab Initio to Oracle STored Procedure.How to do that please explain me...
What are the prioritized Rules in as Transform function
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
What is a ramp limit?
How can we increase the loading performance of oracle table in AbInitio?
How to create a repository in abinitio for stand-alone system(local nt)?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
What are the differences between informatica and abinitio?
Explain PDL with an example?
what is macro?At what situation we have to face?
from a graph how to select only second record always in scan?
Define ramp limit in ab initio?
Teradata 
