Parse a String into Columns and Detail Data

[Gabacho]

I am looking for some assistance in parsing a string that looks like:

Column1:Data1,ratePlan:sample001,Plan:null,port:null,isPMT:null,isNDEL:null,isSample:null,isNew:null,Channel:tst,Line:true

into a file that looks like:

Column1 ratePan      Plan port  isPMT isNDEL isSample isNew Channel Line
Data1      sample001 null   null  null      null       null           null     null        TRUE

[Qiu · Accepted solution]

@Gabacho 
Why channel column is null?