collinp2@gmail.com

Forum Replies Created

Viewing 1 replies (of 1 total)
  • Forum: Plugins
    In reply to: [Exports and Reports] Custom fields containing arrays
    Thread Starter collinp2@gmail.com

    (@collinp2gmailcom)

    13 years, 1 month ago

    Actually… I just figured this out… 

    TRIM(BOTH '"' FROM SUBSTRING_INDEX(SUBSTRING_INDEX(int_4_postmeta.meta_value, ';', 2), ':', -1))
          AS Notes,
       TRIM(BOTH '"' FROM SUBSTRING_INDEX(SUBSTRING_INDEX(int_4_postmeta.meta_value, ';', 4), ':', -1))
          AS Type,
       TRIM(BOTH '"' FROM SUBSTRING_INDEX(SUBSTRING_INDEX(int_4_postmeta.meta_value, ';', 6), ':', -1))
          AS Date
Viewing 1 replies (of 1 total)