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

Answer / hari

string_concat(?,?);
string-lpad();
string_rpad();
string_index();
string_rindex();
string_replase();
like that functions.

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.

What is AB_LOCAL expression where do you use it in ab- initio?

5 Answers   Cognizant,

---

What is the default layout of a component ? Is it mandatory to set the layout of a component ?

3 Answers   IBM,

---

How do you truncate a table?

0 Answers  

---

Describe the effect of the "checkpoint" t-sql statement?

1 Answers  

---

State the relation between EME, GDE and Co-operating system?

0 Answers  

---

Do you think effective communication is necessary for data processing?

0 Answers  

---

i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do we make single a1b2c3d4 and 4 different rows a1, b2, c3,d4.

4 Answers   L&T,

---

After completion of graph what is the next process to perform? who will perform the later process?

1 Answers  

---

What is the significance of ‘mp run’ command ?

1 Answers   TCL,

---

How to add default rules in the transformer?

0 Answers  

---

What are the fundamental blocks of co> operating system of ab initio?

0 Answers  

---

Difference between private project parameters ,public project parameters and common project parameters?

1 Answers  

---