msarro,
When writing regular expressions for TRANSFORMS statements, you don't necessarily need to capture anything. Simply write a regular expression that identifies things you want to nullQueue. For instance if you wanted to nullQueue whenever there is a '3' in column 3 you would specify:
## props.conf
[<spec>]
TRANSFORMS-nullQueue_for_spec = nullQueue_for_spec
## transforms.conf
[nullQueue_for_spec]
## Here we use * to specify 0 or more
REGEX = [^,]*,[^,]*,3,
DEST_KEY = queue
FORMAT = nullQueue
We can add field extraction to events that make it past the nullQueue by adding the following props/transforms:
## props.conf
[<spec>]
KV_MODE = none
REPORT-kv_for_spec = kv_for_spec
## transforms.conf
[kv_for_spec]
DELIMS = ","
FIELDS = column1,column2,column3...
If you really don't want certain columns extracted, instead of specifying FIELDS/DELIMS in your REPORT-kv_for_spec property use a similar regular expression to the nullQueue with capture groups around the columns you want to pull out. The point is separate the nullQueue process from the field extraction process.
Update,
If you were interested in capturing all events, but only certain columns try:
## props.conf
[<spec>]
TRANSFORMS-make_raw_for_spec = make_raw_for_spec
## transforms.conf
[make_raw_for_spec]
DEST_KEY = _raw
REGEX = ([^,]*),([^,]*),([^,]*),
## Drop column 2
FORMAT = $1,$3
... View more