Why is my name value pair being truncated after comma?

[Splunkster45]

Here is what my log looks like:

    Date_filed=record_create_ts
    Grain=D
    Load_Frq=D
    Data=18,2014-05-20
    Number=3,2,169
    Date=2014-05-21,2014-05-22,2014-05-24 

When I run the following command on the log ...| table Number Date

I get the following:

I thought that I would get '3,2,169' instead of just '3'. Does any one know why this is happening?

[DalJeanis]

try this command before the table command

| makemv "," Data Number Date

[somesoni2]

Comma act as pair delimiter if the values are enclosed with double quote. You would need to setup custom field extractions for that type values or update your logging to enclose the values within double quotes.

[Splunkster45]

Thanks, this is super helpful!