split, PostgreSQL - rextester

Language: Layout:

drop table if exists example cascade;

CREATE TABLE example (
	ID	INTEGER NOT NULL PRIMARY KEY,
	Data1	TEXT,
	Data2	TEXT,
	Data3	TEXT,
	Data4	TEXT,
	Data5	TEXT,
	Data6	TEXT
);

INSERT INTO example (ID, Data1, Data2, Data3, Data4, Data5, Data6) 
VALUES (1, 'Lorem ipsum; dolor sit amet, consectetur adipiscing elit.', 'Quisque sit; amet nisi a; augue auctor feugiat.', 'Ut vestibulum ante; vel arcu pellentesque cursus quis accumsan nunc.', 'Duis cursus nisi id quam vestibulum pellentesque.', 'Duis ;tincidunt elit ac ;orci sagittis', 'Nullam et; nunc vulputate, bibendum ex; in, elementum ex.');

select id, 
       split_part(data1, ';', 1) as Data1_Before_Semicolon, 
       split_part(data1, ';', 2) as Data1_After_Semicolon1, 
       split_part(data2, ';', 1) as Data2_Before_Semicolon, 
       split_part(data2, ';', 2) as Data2_After_Semicolon1, 
       split_part(data2, ';', 3) as Data2_After_Semicolon2,
       split_part(data3, ';', 1) as Data3_Before_Semicolon, 
       split_part(data3, ';', 2) as Data3_After_Semicolon1, 
       split_part(data3, ';', 3) as Data3_After_Semicolon2,
       split_part(data4, ';', 1) as Data4_Before_Semicolon, 
       split_part(data4, ';', 2) as Data4_After_Semicolon1, 
       split_part(data4, ';', 3) as Data4_After_Semicolon2,
       split_part(data5, ';', 1) as Data5_Before_Semicolon, 
       split_part(data5, ';', 2) as Data5_After_Semicolon1, 
       split_part(data5, ';', 3) as Data5_After_Semicolon2
from example;


absolute service time: 0,57 sec