What are the different String functions used in Abinitio?
- 3 Answers
- 53679 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
What would be the next step after collecting the data?
Mention what dedup-component and replicate component does?
What are the differences between informatica and abinitio?
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
what is the use of catlog or catlogfile?
What is data mapping and data modelling?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
Mention what is abinitio?
Can anyone give me an exaple of realtime start script in the graph?
What a local lookup is?
Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
What dedup-component and replicate component does?
Define ramp limit in ab initio?
What are the six data process products of ab initio (architecture of ab initio)?
