7 Replies Latest reply: Oct 30, 2012 6:39 AM by aldevinas RSS

    Splitting a field into multiple fields

      Hi dear QV Community

       

      I have a field with information separated by '|', I need to split that into individual fields, as I can do that, can someone help

       

      Original field value:

      _XXX_|MATERIAL|OBRA CIVIL CONTRATADA|MATERIAL|MATERIAL|MATERIAL|MATERIAL|MATERIAL|MATERIAL|MATERIAL|MATERIAL|MATERIAL|MATERIAL|MATERIAL|MATERIAL|MATERIAL

       

      Desired division

      F1F2F3F4F5F6F7F8F9F10F11F12F13F14F15F16
      _XXX_MATERIALOBRA CIVIL CONTRATADAMATERIALMATERIALMATERIALMATERIALMATERIALMATERIALMATERIALMATERIALMATERIALMATERIALMATERIALMATERIALMATERIAL

       

       

      thanks