Convert Wildcards to Range of Records

[#1]

I have a list of zip codes, some of which are wildcarded with '*'.  Each asterisk represents one digit.  For example:

9490* equates to 94900 through 94909

949** equates to 94900 through 94999

Example input:

zip
87124
9490*
123**

I would like the output to look like:

zip
87124
94900
94901
...
94909
12300
12301
...
12399

The "...", of course, are all the other zip codes that would be in the table.

Any ideas how I can go about doing this?

Cheers!

[whiteline]

Yeah, I thought about that... There would be another LOAD to determine the maximum number of asterix.

I think the solution with loops could be more flexible.

For example without limitation that the wildchars should be in the end 😃

[Clever_Anjos]

Hi,

Use Recno() instead, Will fix this