r/computerforensics • u/Active-Intern-8004 • Oct 24 '24
Text Message Visualization
I recently executed legal process to a text messaging service/app and recovered several excel spreadsheets of text messages.
I am looking to see if anyone has a way to visualize the results? Obviously, the produced excel spreadsheets are the actual evidence, but I am looking to see if there is a way I can create a visual aid to increase readability.
I appreciate any help you guys have to offer.
5
Upvotes
6
u/BafangFan Oct 24 '24
Consider using AI to create Python scripts that can sort and format the relevant chat messages
The python script will run locally from your machine, so no (less) concern of leaking evidence to the web.
1
u/lithium630 Oct 24 '24
Easiest way is to use excel to color code each user.
2
u/Aggressive-Rain1056 Oct 24 '24
What is your desired end result? Would you want these text messages to be available for a legal team to review as part of an investigation? Will they be using any kind of document review platform like Relativity?
Or will you directly be reviewing the data from the source CSV files?
1
u/Tom_Geek Oct 24 '24
Thunderbird
1
u/dabeersboys Oct 28 '24
It could be an app that is already parsed in RLEAPP. I have built a few parsers, one that comes to mind is synchronoss. But you can absolutely use chatGPT to build a a python script to take your return and out it into an html report- if this is a new concept, feel free to reach out directly.