topic Re: How do I covert an Object name into columns using a back slash? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-do-I-covert-an-Object-name-into-columns-using-a-back-slash/m-p/441466#M125413 <P>The below query should help you , you can also rename row1, row2 etc. accordingly and display the columns and row that you want using where</P> <UL> <LI> |makeresults|eval x="R:\ClientReports\OpenCaseReport\DataFiles\AmeriHealth_Open\CaseReport_20101210.txt"| makemv delim="\" x|mvexpand x| transpose</LI> </UL> Tue, 29 Sep 2020 22:26:28 GMT Vijeta 2020-09-29T22:26:28Z How do I covert an Object name into columns using a back slash? https://community.splunk.com/t5/Splunk-Search/How-do-I-covert-an-Object-name-into-columns-using-a-back-slash/m-p/441465#M125412 <P>Hello Team,</P> <P>Could anyone help me in spiting an Object name into a column name?</P> <P>Like In Query we are getting Object name as in One Column :</P> <P>R:\ClientReports\OpenCaseReport\DataFiles\AmeriHealth_Open\CaseReport_20101210.txt</P> <P>I wanted to spit that into 6 columns as A ,B,C,D,E,F</P> <P>The output would be like this </P> <P>Header table : A |B|C|D|E|F<BR /> Row Data : R: |ClientReports|OpenCaseReport|DataFiles|AmeriHealthOpen|CaseReportt_20101210.txt</P> Tue, 29 Sep 2020 22:26:22 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-covert-an-Object-name-into-columns-using-a-back-slash/m-p/441465#M125412 shishirkumar 2020-09-29T22:26:22Z Re: How do I covert an Object name into columns using a back slash? https://community.splunk.com/t5/Splunk-Search/How-do-I-covert-an-Object-name-into-columns-using-a-back-slash/m-p/441466#M125413 <P>The below query should help you , you can also rename row1, row2 etc. accordingly and display the columns and row that you want using where</P> <UL> <LI> |makeresults|eval x="R:\ClientReports\OpenCaseReport\DataFiles\AmeriHealth_Open\CaseReport_20101210.txt"| makemv delim="\" x|mvexpand x| transpose</LI> </UL> Tue, 29 Sep 2020 22:26:28 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-covert-an-Object-name-into-columns-using-a-back-slash/m-p/441466#M125413 Vijeta 2020-09-29T22:26:28Z Re: How do I covert an Object name into columns using a back slash? https://community.splunk.com/t5/Splunk-Search/How-do-I-covert-an-Object-name-into-columns-using-a-back-slash/m-p/441467#M125414 <P>it not working if i am remove hardcoded value that is "R:\ClientReports\OpenCaseReport\DataFiles\AmeriHealth_Open\CaseReport_20101210.txt" with my column name ?</P> <P>Could You please help to resolve that.</P> Tue, 29 Sep 2020 22:32:15 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-covert-an-Object-name-into-columns-using-a-back-slash/m-p/441467#M125414 shishirkumar 2020-09-29T22:32:15Z