#!/bin/bash
s=' DOG; CSQ| 0.1234 | abcd | CAT
DOG; CSQ| 0.1234 | abcd | 0 CAT
DOG; CSQ| 0.1234 | abcd | 0.9187 CAT'
sed 's/CSQ.*|.*\t//' <<< "$s"
IyEvYmluL2Jhc2gKcz0nICAgIERPRzsgQ1NRfCAwLjEyMzQgfCBhYmNkIHwgCSBDQVQKICAgIERPRzsgQ1NRfCAwLjEyMzQgfCBhYmNkIHwgMCAJIENBVAogICAgRE9HOyBDU1F8IDAuMTIzNCB8IGFiY2QgfCAwLjkxODcgCSBDQVQnCnNlZCAncy9DU1EuKnwuKlx0Ly8nIDw8PCAiJHMi