[Solved] Split bitstream into 40-bit chunks

[Tailgunner]

I have in a textdocument a long, uninterrupted stream of bits, about 2700.
I would like to import that bitstram in Calc but cut it up in chunks of 40 bits wide.
So each cell should hold 40 bits going from A1 --> An.
I'm very new to Calc, could someone give me some guidance?

[Lupp]

How is the thing you are calling a bit stream represented in the Writer document?

[Tailgunner]

An uninterrupted sequence of 1 and 0, no spaces or other characters.

[Lupp]

Thus you mean characters, not bits, and the stream is a string?
To split a long string in chunks of equal length you need to calculate the starting positions. Then the MID() function is applicable. It can be completed in different ways, either by a formula for array evaluation or by single-cell-formulas. (Many variants.)
See attached example.

stringChunlksOfEqualLength.ods

(15.24 KiB) Downloaded 44 times

[Alex1]

Paste the string to a cell in Calc, then replace (\d{40}) by $1; with regular expressions checked, format as many cells as text as necessary before using Text to columns with ; as separator, and copy the result to one column using the Transpose option.

[karolus]

Hallo

Code: Select all

sed 's/.\{,40\}/&\n/g' bitstream.txt > bitstream_with_breaks.txt

[MrProgrammer]

I have in a textdocument a long, uninterrupted stream of bits, about 2700. I would like to import that bitstram in Calc but cut it up in chunks of 40 bits wide.

Open the text document with Writer.
• Edit → Find & Replace → More options → ✓ Regular Expressions → Search for [01]{40} → Replace with &\n → Replace All
• Uncheck Regular expressions → Close
• Edit → Select All
• Edit → Copy

Open a Calc document.
• Edit → Paste Special → Unformatted Text → OK
• At the bottom, below Fields, click Standard
• Change the Column Type to Text → OK.

[Tutorial] Text to Columns

If you need any additional assistance attach a Writer document with the long bit string (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself). I will not help further unless you attach.

I'm very new to Calc, could someone give me some guidance?

[Tutorial] Ten concepts that every Calc user should know

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.