C_BOWI_40 · Question #48
Which two functions can you use to concatenate the strings "England" and "New" to create the string "New England"?
The correct answer is B. LeftPad() D. Concatenate(). Both Concatenate() and LeftPad() can produce the string 'New England' from the two input strings, while Left() and LeftTrim() serve different purposes.
Question
Which two functions can you use to concatenate the strings "England" and "New" to create the string "New England"?
Options
- ALeft()
- BLeftPad()
- CLeftTrim()
- DConcatenate()
How the community answered
(37 responses)- A8% (3)
- B78% (29)
- C14% (5)
Why each option
Both Concatenate() and LeftPad() can produce the string 'New England' from the two input strings, while Left() and LeftTrim() serve different purposes.
Left() extracts a specified number of characters from the left side of a single string and cannot join two separate strings together.
LeftPad("England"; 11; "New ") pads the string 'England' on its left side with the padding string 'New ' until the total length reaches 11 characters, producing 'New England'.
LeftTrim() removes leading whitespace or specified characters from the beginning of a string and has no ability to join or concatenate two strings.
Concatenate("New "; "England") directly joins the two string arguments in sequence, producing 'New England' as the combined output.
Concept tested: Web Intelligence string concatenation with Concatenate and LeftPad
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/af135fd0571649c9ad35c8aab4490ef6/46d33c946e041014910aba7db0e91070.html
Topics
Community Discussion
No community discussion yet for this question.