Hello, I having trouble with making a simple statement.
I have a list of items that belong in two catagories. The second last character in the item code defines which catagory. is it possible to have a statement that defines whether the item is in catagory a or b.
The trick is that the catagory defining character for an "A" item is either a "P" or "T" and catagory "B" is all other caracters.
ie.
123P6 = "A"
456T2 = "A"
789G1 = "B"
123H5 = "B"
I have a list of items that belong in two catagories. The second last character in the item code defines which catagory. is it possible to have a statement that defines whether the item is in catagory a or b.
The trick is that the catagory defining character for an "A" item is either a "P" or "T" and catagory "B" is all other caracters.
ie.
123P6 = "A"
456T2 = "A"
789G1 = "B"
123H5 = "B"