Split Number Ranges to WildCard Characters

[gayulokesh]

Hi, 

I am working on an input data set which has number ranges like 

42110 - 99999 

I am using generate rows to create number range to individual row which creates 57890 rows, instead I would like to create rows with wildcard where possible like below. Any scalable solution to handle this please ? 

4211* 

4212*

4213*

4214*

4215*

4216*

4217*

4218*

4219*

422**

423**

424**

425**

426**

427**

428**

429**

43***

44***

45***

46***

47***

48***

49***

5****

6****

7****

8****

9****

Regards,

[Qiu]

@danilang 

Sorry for taking long.

I modified the macro to introduce the additional logic you have requested.

Based on my test, it works.

Of course if you have new, we have to modify again maybe. but perhaps not? 😁