What are the different String functions used in Abinitio?
- 3 Answers
- 57097 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 |
If m loading a file of 1 million records.and the graph fails after loading 10,000 records. In this case if we use rollback command then what will happen?
What is the difference between formal and export parameter? Export at what secenario we are going to use?
What is air_project_parameters and air_sandbox_overrides? what is the relation between them?
what is skew and skew measurement?
What is the difference between partitioning with key / hash and round robin?
What is a rollup component?
What is the difference between check point and phase?
What is the Reformat Layout?(i/p ->Reformat->o/p)
What are the primary keys and foreign keys?
Have you worked with packages?
Explain the ab initio etl tool in high level?
What is $mpjret?
Teradata 
