Forum Discussion

eamonnj1982's avatar
eamonnj1982
Frequent Visitor
9 years ago

Split Columns

I have a column of merged data which stores a type and a number and sometimes several types and numbers.

 

I would like to br able to report on the different types and their values but I can't figure out the best way to do this. 

 

An example of the data in this column is shown below....

 

Anyone have any thoughts?  Many thanks

 

COLUMN A

Type C: 8; Type F: 2;Type B: 4;Type L: 4;

Type A: 15; Type C: 15;

Type C: 6; Type B: 6;

 

Need Help

3 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

    Hi There,

     

    You can use the split columns functionality in query mode. Please refer to this attached photos for stepwise procedure.

     

     

     

     

     

     

     

     

     

    Thanks & Regards,

    Bhavesh 

    • quratzafar's avatar
      quratzafar
      Advocate II
      9 years ago

      This is your sample column, "Type C: 8; Type F: 2;Type B: 4;Type L: 4;"

      Split first by the delimiter ';' and then split the resulting colums by delimiter ':'. Shouldn't cause a probem ideally