QUOTE (John Spencer @ Aug 8 2011, 09:47 AM)
I would like to help, but at this point I am confused on what you want.
Given that a field contains WD,LI,AI,LD
What results exactly do you want?
Do you want a field (column) that contains WD and another that contains LI and another that contains AI and another that contains LD?
Do you want a field that contains All four values if (for instance) LI is contained in the string?
Or do you want one field that contains WD and LI if you are looking for those two values?
Thank you John as I greatly appreciate your willingness to assist.
The field entitled "Customer" for all purposes contains various results separated by a comma. There are over 50 different entry variations that may be made so the best way I figured to do this was to use a wild card search as each character in the series "WD", "LI", "AI" etc etc is actually a separate category. So Like "W*
" would also be WD,WV,WI, WX etc etc.
Now to the tricky part, so all of these answers are within the category "Customer"
Now I need a new Field so that I may separate them into their appropriate categories based upon the first letter in the series. The tricky part here is that there are like categories that will need to be grouped. So LIKE "W*"
and LIKE "A*"
will be grouped in one Field we'll call this field "CUSTOMER_2"
Example here is using the previous example of "WD,LI,AI,LD "
Under the new Category..."Customer 2" we will have WD,WV,WI,AI
I hope this did not confuse anyone but in fact give more detail into my dilemma.