Hi,
I want to split the ID based on the Alfa and Numeric, so i used the following formula, which is working fine up to some extent.
ID: BLOCK1002XY
For Numeric i wrote
numbervar x;
stringvar a:= '';
for x:= 1 to length() do if isnumeric( [x] ) then
a:= a + [x]
else a;
a
Iam getting the out put 1002, which is fine.
But for ALFA i wrote
numbervar x;
stringvar a:= '';
for x:= 1 to length() do if NOT (isnumeric( [x] )) then
a:= a + [x]
else a;
a
Iam getting the out put BLOCKXY, which i donu2019t want; i want only BLOCK from ID as a single word and XY as single word from the ID,
OR
is their any way of spliting the ID as BLOCK as one and 1002XY as other, somthing like splitting from Numaric charecter
Any one helps me on this.
Thanks,
Krish...
Edited by: Krish GDV on May 13, 2010 10:56 AM
Edited by: Krish GDV on May 13, 2010 11:30 AM