This content has been marked as final. Show 2 replies
Got a new question going slightly beyond the question I asked in the morning.
Assume the table I am referring looks as below,
This time I want to filter the data based on the below requirements;
1. Select the last two characters of the Item_Code.
2. I want to Flag/Filter the Item_Codes which ONLY got "CD" letters at the END.
Item_Code could just "CD" or it could be the last two letters of a text value.
The out put should be something like below,
Could anyone help me with the above task, would be greatly appreciated.