Skip to Content
0
Former Member
May 13, 2010 at 03:56 PM

Formatting issue

26 Views

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