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:



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




      app: company id

      app_name: company name



      Thank you,