C_BOWI_40 · Question #148
Which two character functions can modify character string and return the word "Department" from the string "Department Fast Foods"? (Choose two.)
The correct answer is B. SubStr() D. Replace(). SubStr() extracts a portion of a string by position and length, while Replace() removes or substitutes a substring - both can isolate 'Department' from 'Department Fast Foods'.
Question
Which two character functions can modify character string and return the word "Department" from the string "Department Fast Foods"? (Choose two.)
Options
- APos()
- BSubStr()
- CLength()
- DReplace()
How the community answered
(45 responses)- A11% (5)
- B84% (38)
- C4% (2)
Why each option
SubStr() extracts a portion of a string by position and length, while Replace() removes or substitutes a substring - both can isolate 'Department' from 'Department Fast Foods'.
Pos() returns the numeric position of a substring within a string and does not modify or return a transformed string value.
SubStr('Department Fast Foods', 1, 10) returns the first 10 characters of the string, yielding 'Department' by specifying the starting position and the character count to extract.
Length() returns the integer count of characters in a string and does not extract or modify string content.
Replace('Department Fast Foods', ' Fast Foods', '') substitutes the unwanted trailing text with an empty string, leaving only 'Department' as the result.
Concept tested: Web Intelligence SubStr and Replace character string functions
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/1a61583f-f2a5-4928-a9e7-a35f8b849dc7/46108a526e041014910sce01.html
Topics
Community Discussion
No community discussion yet for this question.