Search Results
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.
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.
Page 1