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



      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?