Forum Discussion

Chrisss14's avatar
Chrisss14
Frequent Visitor
3 years ago
Solved

Group By End Character

Hey All,    I've created a filter using GROUP = LEFT([versionDescription], 3) which groups by the first 3 characters.    i.e BTL0023 is grouped into the BTL catergory.    Some of these descript...
Need Help
Tips and Tricks
  • jgeddes's avatar
    jgeddes
    3 years ago

    If I assume that [versionDescription] is normally 7 characters in length you can use something like

    GROUP2 = 
    var _length =
    LEN([versionDescription])
    Return
    IF(
    _length > 7,
    RIGHT([versionDescription], _length - 7),
    BLANK()
    )

jgeddes's avatar
jgeddes
Super User
3 years ago

If I assume that [versionDescription] is normally 7 characters in length you can use something like

GROUP2 = 
var _length =
LEN([versionDescription])
Return
IF(
_length > 7,
RIGHT([versionDescription], _length - 7),
BLANK()
)