3 Replies Latest reply: Nov 6, 2012 3:25 AM by Vegar Lie Arntsen RSS

    Loading descriptions in different formats into labels

      Dear all,

       

       

      I have tried Mapping with wildcards from the QV Cookbook (http://robwunderlich.com/downloads/)  example "Mapping with a table using wildcards" .

       

      This works perfect for a few lines, but If I want to use it for more than approx 10 statements than it's not working anymore.

       

       

      It's for using in a qwv for bankstatements. The used discription is always mixed in length, place of the needed part and use of numbers and letters. Eg

       

      Descriptions:

      1256 SUPER 56    

      1 NEXT FIRM 55663

      PLACE 69.12.63

       

      I want to have then:

      Descriptions:                   Key:                    Label1               Label2          Label3

      1256 SUPER 56               *SUPER*             FOOD               BREAD          CompanyA

      1299 SUPER 56               *SUPER*             FOOD                     BREAD     Company A

      1 NEXT FIRM 55663          *FIRM*               FOOD                  MEAT          CompanyB

      PLACE 69.12.63               *69.12*               BANK               BANK               CompanyC

       

      Etc etc for many (approx 100) descriptions.

       

      Then in the dashboard I want to see eg all "BREAD" or "Company A".

       

      Anyone have a solution? Maybe a loop?