Search Results

Found 1 results for "6ce03f34c7d26c4b865527fba3622b0a" across all boards searching md5.

Anonymous /wsr/1530049#1530049
6/14/2025, 9:49:45 PM
I have a .txt file with numbers. There's a new line after every number. There could be 10000 numbers in that file or more. Now i need to transform this data so that there's a line break after 96 numbers. It's for reverse engineering data packets of 96 bytes with numerical values. So i need an easy way to see how every byte changes over time. Just a simple table like in pic related is fine. Where after 96 characters a new line starts over. I have tried google with no success. Tried AI and only chatGPT helped me with a macro for LibreOffice Calc, but it doesn't work when i tried adding more data. Also Calc has limit on amount of new lines so it won't work with a huge data log. So if there's a better way than Calc, That'd be great.

Sub TransformToColumns()
Dim srcSheet As Object
Dim dstSheet As Object
Dim i As Long, row As Long, col As Long
Dim value As Variant

srcSheet = ThisComponent.Sheets(0)
dstSheet = ThisComponent.Sheets(0)

i = 0
Do
value = srcSheet.getCellByPosition(0, i).String
If value = "" Then Exit Do

row = Int(i / 96)
col = i Mod 96
dstSheet.getCellByPosition(col + 1, row).String = value
i = i + 1
Loop
End Sub

A way to make graphs with how the data changes over time would be 100 times more helpful. Something akin to Savvycan graph making capability.