https://community.splunk.com/t5/Splunk-Search/Expanding-rows-to-certain-number-of-rows/m-p/123614#M33384 <P>Append this to your search:</P> <PRE><CODE>... | eval temp = replace(tostring(pow(10, count-1)), "(\d)", "\1,") | makemv temp delim="," | mvexpand temp | fields - temp </CODE></PRE> Thu, 31 Oct 2013 13:26:53 GMT martin_mueller 2013-10-31T13:26:53Z https://community.splunk.com/t5/Splunk-Search/Expanding-rows-to-certain-number-of-rows/m-p/123613#M33383 <P>Hi!</P> <P>I would like to get some help with search commands.<BR /> I have a result like,</P> <PRE><CODE>string dT count 1412175602_AAA_T1_32 4 1 1412125204_AAA_T1_34 2 3 1380813000_AAA_T2_50 16 2 </CODE></PRE> <P>In this situation I want to expand the rows of number of counts</P> <PRE><CODE>string dT 1412175602_AAA_T1_32 4 1412125204_AAA_T1_34 2 1412125204_AAA_T1_34 2 1412125204_AAA_T1_34 2 1380813000_AAA_T2_50 16 1380813000_AAA_T2_50 16 </CODE></PRE> <P>Would there any way to do this?</P> <P>Any help is appreciated!</P> <P>Thanks,<BR /> Yu</P> Thu, 31 Oct 2013 01:35:15 GMT https://community.splunk.com/t5/Splunk-Search/Expanding-rows-to-certain-number-of-rows/m-p/123613#M33383 yuwtennis 2013-10-31T01:35:15Z https://community.splunk.com/t5/Splunk-Search/Expanding-rows-to-certain-number-of-rows/m-p/123614#M33384 <P>Append this to your search:</P> <PRE><CODE>... | eval temp = replace(tostring(pow(10, count-1)), "(\d)", "\1,") | makemv temp delim="," | mvexpand temp | fields - temp </CODE></PRE> Thu, 31 Oct 2013 13:26:53 GMT https://community.splunk.com/t5/Splunk-Search/Expanding-rows-to-certain-number-of-rows/m-p/123614#M33384 martin_mueller 2013-10-31T13:26:53Z