$ cat sobazar_events_reff_external.tab | awk '{if ($20 ~ /prod/) { print $0; }}' > outputfile.tab

sed -e 's/"{/{/g;s/\}"/\}/g;s/\\"/"/g' sobazar_events_reff_external.tab > valid.tab

$ sed -e 's/content:interact:product_wanted/product_wanted/g;s/content:interact:product_clicked/product_detail_clicked/g;s/purchase:buy_clicked/product_purchase_intended/g;s/content:interact:product_detail_viewed/product_detail_clicked/g' in.tab > out.tab

cat sobazar_events_prod_cleaned_formatted.tab | awk -F'\t' '{ if($34 > 1383264000000) { print; }}' > sobazar_events_prod_cleaned_recent.tab