Arpeggio 2.0 filtering errors

[kelyco]

I^m trying to filter out unwanted records. When I try to eliminate id^s ending with "S", Arpeggio Report Designer won^t do it. I^ve tried all possible elimination schemes (not like, not equal to, not in the list, not in the range) but nothing works. If I eliminate 0009, 0009S still shows up. If I eliminated 0009S, 0009S and 0009 show up. It^s as if Arpeggio isn^t looking at the 5th character in the string. I can put in a substring identifying the 5th character, but that^s really too much work. I should be able to filter the RENT.ID record alone. Any suggestions to cure what ails Arpeggio?

[kfleming]

Did you try the filter:____RENT.ID not like "*S"____The * acts as a wildcard in this expression and should return all records where RENT.ID does not end in an S.____Kathleen__R&R Support______

[kelyco]

Yes, I tried ^*S^ and it didn^t work. I didn^t mention in my original posting that this report I created joins 2 files. I^ve tried eliminating all of the rent category filters that I need to see if the rent id will filter correctly, but it doesn^t. ____

[kfleming]

Try:__"????S*"____this says anything where S is in the 5th character position and looks for any trailing characters as well.____Kathleen__R&R Support

[kelyco]

I^ve tried that, too. I^ve tried every possible wildcard character once and 4 times. It just seems that for some reason, Arpeggio isn^t reading that data field as 4 #s followed, sometimes, by an alpha character. Could that be a problem ... sometimes the RENT.ID field has 4 characters, sometimes it has 5?

[kfleming]

I do not know of any reason why the wildcard should not work.____Kathleen__R&R Support