How can I match a column/value which ends in a certain pattern A4, D4 here in Spotfire reports?

[Enkeled Kanaj]

Hi,

 

Just wanted to share how I matched a value with regular expression in Spotfire report by creating a calculated column. in this case we use "case when then" instead of "if, elseif, then" used in other BI-s

option 1

CASE  WHEN (right([EutranCellFDD],2)='A4') or (right([EutranCellFDD],2)='D4') or (right([EutranCellFDD],2)='N4') or (right([EutranCellFDD],2)='K4') or (right([EutranCellFDD],3)='D42') THEN 'Sector1' WHEN (right([EutranCellFDD],2)='B4') or (right([EutranCellFDD],2)='E4') or (right([EutranCellFDD],2)='O4') or (right([EutranCellFDD],2)='L4') or (right([EutranCellFDD],3)='E42') THEN 'Sector2' WHEN (right([EutranCellFDD],2)='C4') or (right([EutranCellFDD],2)='F4') or (right([EutranCellFDD],2)='P4') or (right([EutranCellFDD],2)='M4') or (right([EutranCellFDD],3)='F42') THEN 'Sector3' ELSE 'Sector4' END

 

otion 2

CASE  WHEN ([EutranCellFDD]~='A4$') or ([EutranCellFDD]~='D4$') or ([EutranCellFDD]~='N4$') or ([EutranCellFDD]~='K4$') or (
 [EutranCellFDD]~='D42$') THEN 'Sector1' WHEN ([EutranCellFDD]~='B4$') or ([EutranCellFDD]~='E4$') or ([EutranCellFDD]~='O4$') or ([EutranCellFDD]~='L4$') or ([EutranCellFDD]~='E42$') THEN 'Sector2' WHEN ([EutranCellFDD]~='C4$') or ([EutranCellFDD]~='F4$') or ([EutranCellFDD]~='P4$') or ([EutranCellFDD]~='M4$') or ([EutranCellFDD]~='F42$') THEN 'Sector3' ELSE 'Sector4' END

 

 

[Heleen Snelting]

Thanks for sharing the above @Enkeled Kanaj !

If anyone uses this solution, please add a comment. And we can turn this type of content into a community article as well.

Heleen