[SOLVED] Extract data using Shell/python script from a text file

Issue

I have a large text file with data as follows

889143359540998144 column=clean-tweet:clean_tokens, timestamp=1511684776520, value=make;sure;youre;ready;safely;view;solar;eclipse;aug;21;check;tip;eclipse;.

I need to extract data from it(first id and value) in a format such as below and store it in a text file.

889143359540998144   make,sure,youre,ready,safely,view,solar,eclipse,aug,21,check,tip,eclipse,.

Can anyone please help in extract this using shell script or python

Solution

I can think of a fairly easy way using the shell:

awk -F'[ =]' '{print $1" "$NF}' your_file.txt | sed 's/;/,/g

Assuming your file is named your_file.txt

Answered By - AnythingIsFine