Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert Wildcards to Range of Records

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!

11 Replies
whiteline
Master II
Master II

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
Employee
Employee

Hi,

Use Recno() instead, Will fix this