How to make numbers from a range

[marcel_olmo]

Hi guys,

I have a table like this :

Code

08000-08042

08060

08061

And I'd like to get this result :

Code

08000

08001

08002

08003

...

08042

08060

08061

How could I get that?

Regards, Marcel.

[sunny_talwar]

Try this

Table:

LOAD *,

Start + IterNo() - 1 as NewCode

While Start + IterNo() - 1 <= End;

LOAD Code,

SubField(Code&'-', '-', 1) as Start,

SubField('-' & Code, '-', -1) as End;

LOAD * INLINE [

    Code

    08000-08042

    08060

    08061

];