Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different String functions used in Abinitio?
- 3 Answers
- 59104 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain data flow graph with an example?
How to compare two dmls in abinitio
What is $mpjret?
Explain what is sandbox?
Within a cursor, how would you update fields on the row just fetched?
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
Explain what is de-partition in abinitio?
What do you understand by a cartesian join?
List out the file extensions used in abinitio?
What is the purpose of having stored procedures in a database?
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)?
Have you used the rollup component? Describe how?
What is the use of the co> operating system in ab initio?
What the difference between “look-up” file and “look is up” in abinitio?
Can you explain the co>operating system’s processing model?
