June 20, 2012 \ Ananth TM \ 1 Comment Datastage String Functions Function Usage AlNum Cab be used to check if the given string has alphanumeric characters Alpha TRUE if string is completely alphabetic CompactWhiteSpace all consective whitespace will be reduced to single space Compare Compares two strings for sort ComparNoCase Compare two strings irrespective of Case in-sensitiveness ComparNum Compare the first n characters of the two strings CompareNumNoCase Compare first n characters of the two strings irrespective of case in-sensitiveness Convert Replace character in a string with the given character. Count Count number of times a given substring occurs in a string Dcount Returns count of delimited fields in a string DownCase Change all uppercase letters in a string to lowercase DQuote Enclose a string in double quotation marks Field Return 1 or more delimited substrings Index Find starting character position of substring Left Finds leftmost n characters of string Len Length of the string or total number of characters in a string Num Return 1 if string can be converted to a number PadString Return the string padded with the optional pad character and optionallength Right Finds Rightmost n characters of string Soundex Returns a string which identifies a set of words that arephonetically similar Space Return a string of N space characters Squote Covers a string into single quotation marks Str Repeat a string StripWhiteSpace Return the string after removing all whitespace Trim Remove all leading and trailing spaces and tabs. Also reduce the internal occurrences of spaces and tabs into one. TrimB Remove all trailing spaces and tabs TrimF Remove all leading spaces and tabs Trim Returns a string with leading and trailing whitespace removed Upcase Change all lowercase letters in a string to uppercase
Camelia Rashada says December 18, 2022 at 1:22 pm RS SEO Glasgow, 272 Bath St, Glasgow G2 4JR, 07460397220, rsseoglasgow . com Reply