Hi there,
I am building a view where there is a categorized column that will use a field which is a project code that is a mix of text and number (3 or 4 digit at the end separated by space from the text) - the length of text is varying …
Is there a way i could filter out only the numeric part of this field and use it to display as expandable categories ?
Thanks for any suggestions !
Subject: Categorized view
If the format is always consistent Alpha Space Number, you could use @Rightback(PRojNum;" ") This will give you everything to the right of the space. You can put this in a hidden computed field on your form so you don’t have to compute it in your view, then use that field as the category field.
HTH - regards
Subject: RE: Categorized view
This is super!
Thanks a lot Joffrey …