Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Load
SubField(CODE-PHNNO,'-',1) as CODE,
SubField(CODE-PHNNO,'-',-1) as PHNNO
From TableName;
try like this?
=subfield(CODE-PHNNO, '-',1) as Code
=subfield(CODE-PHNNO, '-',2) as PHNNO
Load
SubField(CODE-PHNNO,'-',1) as CODE,
SubField(CODE-PHNNO,'-',-1) as PHNNO
From TableName;