开云体育

Hi Rowan,

in case you're into processing plain text files from the Linux console, here's what I use.

I'm assuming one is starting from the chat log file created by Zoom: meeting_saved_chat.txt

Cheers,
Rolf

Remove all privately sent messages

(leaves only messages sent to "Everyone")

sed '/^[0-2][0-9]\:[0-5][0-9]\:[0-5][0-9].*\(Privately\)/,/^[0-2][0-9]\:[0-5][0-9]\:[0-5][0-9]/{/^[0-2][0-9]\:[0-5][0-9]\:[0-5][0-9]/!d}; /^[0-2][0-9]\:[0-5][0-9]\:[0-5][0-9].*\(Privately\)/d' meeting_saved_chat.txt > only_messages_to_everyone.txt

a) Remove timestamp & "From", but leave Zoom's ugly "dangling" colon

(results in "John Doe : Hello World!")

sed 's/^[0-2][0-9]\:[0-5][0-9]\:[0-5][0-9]\s*From\ //' only_messages_to_everyone.txt > no_prefix.txt

b) Remove timestamp & "From", but make colon follow name directly

(results in "John Doe: Hello World!")

sed -r 's/^[0-2][0-9]\:[0-5][0-9]\:[0-5][0-9]\s*From (.*)\ \:/\1\:/' only_messages_to_everyone.txt > no_prefix.txt

c) Remove timestamp & "From" & name

(results in "Hello World!")

sed -r 's/^[0-2][0-9]\:[0-5][0-9]\:[0-5][0-9]\s*From (.*)\ \: //' only_messages_to_everyone.txt > no_prefix.txt

d) Remove timestamp & "From" & name, add blank line after each? message

(results in "Hello World!", followed by an empy line)

sed -r 's/^[0-2][0-9]\:[0-5][0-9]\:[0-5][0-9]\s*From (.*)\ \: /\n/' only_messages_to_everyone.txt > no_prefix.txt

--
?If it works, it's right.? · ?Richtig ist, was funktioniert.?
 · 

Rowan Francis Simonsen schrieb am 14.09.20 um 16:36:

A quick question:?

Does anyone have experience with how to export the content of the zoom chat in a cleaned up version, without names and dates of each entry?

I am playing with the idea of copying into a spreadsheet and ordering all posts alphabetically and deleting all the lines that say "From...."

But it seems like there should?be an easier way.

Looking forward to hear what you are learning about this?

Cheers,

Rowan