How do I covert an Object name into columns using a back slash?

[shishirkumar]

Hello Team,

Could anyone help me in spiting an Object name into a column name?

Like In Query we are getting Object name as in One Column :

R:\ClientReports\OpenCaseReport\DataFiles\AmeriHealth_Open\CaseReport_20101210.txt

I wanted to spit that into 6 columns as A ,B,C,D,E,F

The output would be like this

Header table : A |B|C|D|E|F
Row Data : R: |ClientReports|OpenCaseReport|DataFiles|AmeriHealthOpen|CaseReportt_20101210.txt

[Vijeta]

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

• |makeresults|eval x="R:\ClientReports\OpenCaseReport\DataFiles\AmeriHealth_Open\CaseReport_20101210.txt"| makemv delim="\" x|mvexpand x| transpose

[shishirkumar]

it not working if i am remove hardcoded value that is "R:\ClientReports\OpenCaseReport\DataFiles\AmeriHealth_Open\CaseReport_20101210.txt" with my column name ?

Could You please help to resolve that.