Hey, am trying to filter data from my DB into a model. The column that I need to filter has data in the structure 4FF104F0C999CAT67233AD04FACB13B9:0500157842. I have tried a custom expression, "substring([Column], 33, 10)" because the position of the colon always remains the same on all records. In my case, I need to ensure only distinct values of the second part (0500157842) are displayed. Please help...
And whats wrong with the substring method?