gistfile1.txt

function(str){var ls=str.split(' - ')[1].split(', ').map(function(x){return x.split('[').join('').split(']').join('').trim()}).reduce(function(acc,cur,i){if(cur.split(': ').length>1){key=cur.split(': ')[0].trim();key=key.split(' ').join('_').toLowerCase();if(key=='advertiser_domains'){val=cur.split(': ')[1].trim().split(',')}else{val=cur.split(': ')[1].trim()}acc[key]=val}else{key=cur;val='random';acc[key]=val}return acc},{});timestamp=str.trim().slice(0,19);timestamp=timestamp.slice(0,10)+'T'+timestamp.slice(11,19);key='timestamp';ls[key]=timestamp;ls.floor_price=parseFloat(ls.floor_price)||0.0;ls.cpm=Number(ls.cpm)||0.0; ls.gross_price = Number(ls.gross_price) || 0.0; ls.net_price = Number(ls.net_price) || 0.0; ls.ssp_auction_price =  Number(ls.ssp_auction_price) || 0.0; ls.dsp_bid_price=Number(ls.dsp_bid_price) || 0.0;  ls.date_utc=timestamp.slice(0,10);ls.year=timestamp.slice(0,4);ls.month=timestamp.slice(5,7); ls.day=timestamp.slice(8,10);ls.hour=timestamp.slice(11,13); return ls}