topic Splunk field extractor ignors comma towards the end in Getting Data In https://community.splunk.com/t5/Getting-Data-In/Splunk-field-extractor-ignors-comma-towards-the-end/m-p/545224#M90916 <P>I have a CSV with the following data</P><P>&nbsp;</P><LI-CODE lang="markup">19,john doe,blue car,NAY,NA,YAY,,NIL,,,,NA,,</LI-CODE><P>&nbsp;</P><P>There are 14 fields in the above line, but when I try the automatic field extractor via "Extract more fields", It only recognizes 13 fields.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fx1.JPG" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/13470i34753C8F102BC75C/image-size/medium?v=v2&amp;px=400" role="button" title="fx1.JPG" alt="fx1.JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fx2.JPG" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/13469i4B768025953F1FF3/image-size/medium?v=v2&amp;px=400" role="button" title="fx2.JPG" alt="fx2.JPG" /></span></P><P>Why is the field extractor dropping the last field ?</P> Wed, 24 Mar 2021 20:39:31 GMT termcap 2021-03-24T20:39:31Z Splunk field extractor ignors comma towards the end https://community.splunk.com/t5/Getting-Data-In/Splunk-field-extractor-ignors-comma-towards-the-end/m-p/545224#M90916 <P>I have a CSV with the following data</P><P>&nbsp;</P><LI-CODE lang="markup">19,john doe,blue car,NAY,NA,YAY,,NIL,,,,NA,,</LI-CODE><P>&nbsp;</P><P>There are 14 fields in the above line, but when I try the automatic field extractor via "Extract more fields", It only recognizes 13 fields.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fx1.JPG" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/13470i34753C8F102BC75C/image-size/medium?v=v2&amp;px=400" role="button" title="fx1.JPG" alt="fx1.JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fx2.JPG" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/13469i4B768025953F1FF3/image-size/medium?v=v2&amp;px=400" role="button" title="fx2.JPG" alt="fx2.JPG" /></span></P><P>Why is the field extractor dropping the last field ?</P> Wed, 24 Mar 2021 20:39:31 GMT https://community.splunk.com/t5/Getting-Data-In/Splunk-field-extractor-ignors-comma-towards-the-end/m-p/545224#M90916 termcap 2021-03-24T20:39:31Z