For your sourcetype, you should be setting you delimiter in props for CSV..
props.conf
[mycsvsourcetype]
HEADER_FIELD_LINE_NUMBER=1
TIMESTAMP_FIELDS=date
FIELD_DELIMITER=,
Your sources need to be consistent in terms of the header existing.
Once indexed correctly, you can search for fields as desired:
sourcetype=mycsvsourcetype Color=red | table Color, Data1,Data2
That will return all events with the field named Color, that has the value of red. Do note, field names are case sensitive. So if your header is "Color" and "Data1", you have to use those fields names.
... View more