नोट
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप साइन इन करने या निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
Returns a substring from within a string.
Syntax
SUBSTRING(string, start, length)
string |
Specifies the string from which a substring is extracted. |
start |
Specifies the start position within the string. |
length |
Specifies the number of characters. |
Example
| Formula | Result |
|---|---|
SUBSTRING(Address Line, 5, 20) |
Returns a substring for each instance of the Address Line field that begins at the fifth character of the string and ends at the 20th character. For example, the following string: "#9900 2700 Production Way" returns the following substring: "0 2700 Production Wa". |
SUBSTRING("lavender", 3, 5) |
"vende" |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Text Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Data, Text, and Images (Report Builder)