You’re offline. This is a read only version of the page.
The length of substring can't be longer than '1962' which is the length of the source string.
Hi @Anonymous,
Like the error mentions. The substring function expects the following format
Share
Report
All responses (
Answers (
substring('<text>', <startIndex>, <length>)
The last part, the length cannot be longer than the actual length of the source string. That is what the error means.
If you don't know or want to use a length calculation at all I would suggest to use a slice function instead. That function does not require a length.
slice('<text>', <startIndex>, <endIndex>?)
#1
WarrenBelz
146,605
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
