6 Replies Latest reply: Dec 8, 2012 12:17 AM by Juan Semaan RSS

    Best aproach for extracting ids from string

      Hi everyone,

       

      I have a mass mailer program installed in my server which creates metrics from the emails delivered. This data is stored in a data base, but I encountered a problem to extract the ids from the users that opened the email.  Each campaign I send, stores the ids of the users that opens the email in a row using the following format:

      2.jpg

       

      One row for each campaign..

      example: 6130:CO    

      6130 is the id for the user and CO is the country

       

      I want to be able to select the campaign title and to see which users opened that campaign. This is the layout..

       

      1.jpg

       

      app: company id

      app_name: company name

       

       

      Thank you,

       

      Juan.