11 Replies Latest reply: Aug 30, 2013 11:58 AM by Clever Anjos RSS

    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!