A report author wants to use a calculation which is not a string function to manipulate text.
Which function can be used?
A report author wants to use a calculation which is not a string function to manipulate text.
Which function can be used?
The extract() function is used to manipulate text based on a specific pattern. Unlike functions such as trim() and lower(), which specifically modify text by removing whitespace or changing case, extract() can retrieve portions of text based on criteria like matching specific patterns or sequences. Therefore, it can be used for more complex text manipulations that do not fall under simple string functions.
incorrect Extract is correct , answer C A list of the ESQL string manipulation functions that you can use. https://www.ibm.com/support/knowledgecenter/SSTTDS_11.0.0/com.ibm.etools.mft.doc/ak05190_.html
I agree, right answer is C