https://community.splunk.com/t5/Splunk-Search/How-to-count-the-number-of-columns-in-a-file/m-p/325297#M164481 <P>Hi,</P> <P>I'm trying to do a comparison, wherein I want to verify that the number of columns in file X matches the number of columns in file Y.</P> <P>Its literally a comparison of two figures.</P> <P>Does anyone have any idea? I was thinking of using fieldsummary, but I'm not quite sure on how to implement it</P> <P>Thanks</P> Fri, 08 Dec 2017 10:11:59 GMT mahbs 2017-12-08T10:11:59Z https://community.splunk.com/t5/Splunk-Search/How-to-count-the-number-of-columns-in-a-file/m-p/325297#M164481 <P>Hi,</P> <P>I'm trying to do a comparison, wherein I want to verify that the number of columns in file X matches the number of columns in file Y.</P> <P>Its literally a comparison of two figures.</P> <P>Does anyone have any idea? I was thinking of using fieldsummary, but I'm not quite sure on how to implement it</P> <P>Thanks</P> Fri, 08 Dec 2017 10:11:59 GMT https://community.splunk.com/t5/Splunk-Search/How-to-count-the-number-of-columns-in-a-file/m-p/325297#M164481 mahbs 2017-12-08T10:11:59Z https://community.splunk.com/t5/Splunk-Search/How-to-count-the-number-of-columns-in-a-file/m-p/325298#M164482 <P>Can you please elaborate your question?<BR /> Give us sample input data and tell us the output you want so that I can write a query for you.</P> Fri, 08 Dec 2017 10:43:42 GMT https://community.splunk.com/t5/Splunk-Search/How-to-count-the-number-of-columns-in-a-file/m-p/325298#M164482 mayurr98 2017-12-08T10:43:42Z https://community.splunk.com/t5/Splunk-Search/How-to-count-the-number-of-columns-in-a-file/m-p/325299#M164483 <P>Are these indexes or lookups?</P> <P>At any rate, to do it for one, you’d use something like <CODE>...|fieldsummary |stats count as fields</CODE> And you can join or append the other file</P> Fri, 08 Dec 2017 12:14:53 GMT https://community.splunk.com/t5/Splunk-Search/How-to-count-the-number-of-columns-in-a-file/m-p/325299#M164483 cmerriman 2017-12-08T12:14:53Z