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 descriptions have extra characters at the end which I would also like to group by. What would be the best way to do this? 

 

i.e I have LTD0002G and LTD0004PT and I want to group the values by G and PT in this scenario. 

 

Thanks!

 

 

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()
    )

1 Reply

  • jgeddes's avatar
    jgeddes
    Icon for Super User rankSuper 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()
    )