Separating Data into Separate Columns

[#1]

Hi

I have data like this:   

CODE-PHNNO

08649-235645

0866-2457896

040-2424578

022-7896325

subfield(CODE-PHNNO, '-')AS CODE  THE RESULT IS

CODE

08649

235645

0866

2457896 LIKE THIS

BUT I WANT CODE SEPARATE AND PHNNO SEPARATE HOW CAN I?

THANKS

MADHU

[Anonymous]

try like this?

=subfield(CODE-PHNNO, '-',1) as Code

=subfield(CODE-PHNNO, '-',2) as PHNNO

[MK_QSL · Accepted solution]

Load

     SubField(CODE-PHNNO,'-',1) as CODE,

     SubField(CODE-PHNNO,'-',-1) as PHNNO

From TableName;