convert one column data into two column with help of delimiter

[Kohli]

i have data like

Flight code,     

JJ-DL,

IB-UA

LH-UA

BA-UA

LH-AA

AA-UA

QZ-SQ

UA-WS

UA-AI

AA-UA

UA-DY

I want dived it into 

Flight1, flight2

JJ,DL,

IB,UA

LH,UA

BA,UA

LH,AA

AA,UA

QZ,SQ

UA,WS

UA,AI

AA,UA

UA,DY

[jaumecf23]

Hi,

Try this:

Table1:

Load*,

SubField([Flight code],'-',1) as Flight1,

SubField([Flight code],'-',2) as Flight2

;

LOAD * INLINE [

Flight code  

JJ-DL

IB-UA

LH-UA

BA-UA

LH-AA

AA-UA

QZ-SQ

UA-WS

UA-AI

AA-UA

UA-DY

];