Hello,
someone has destroyed my datasheet, I dont know how but it used to be a table with one digit in every cell, now I have only one huge number with 4934 cyphers together. How can I put it back to any calculating spreadsheet or a table but that way, that I have only one cypher in every cell. Please, somebody, help me, otherwise I will have to make it number by number (with Tab button in between used 4934 times). Have mercy!!! :-))
Do you have backup files of your important documents? It is easier to open one of them…
No i dont have backup, Im putting those numbersby hand one by one while I calculate them, 20 to 50 per one time Im busy with it. I thought that in worse case scenario I will loose last sesion, I would just write them again.
Please upload your ODF type document here.
I dont know how to upload it here, its .odt extension but there is nothing more there, only 4934 figures in one raw, no spaces between, just like that 9809870938709356754465434334… I can send that number here in 5 separate comments, or I need an advise, how to upload it
How many columns your table had?
hello @wargul33,
‘someone’ - who?
if file still open try undo [ctrl-z],
‘backup’ - sometimes you have and don’t know, [tools - options - load/save - general - always create a backup copy], if set try not! to destroy it by new saves! - if not activated do so now, and create add. backups on other media in the future,
if it’s really all single! digits there is a possibility:
find and replace (ctrl-h) ‘1’ by ‘1;’ ‘replace all’,
repeat for 2…0,
(if you are fit with regular expressions you may find smarter way),
copy cell to notepad [cell - F2 - ctrl-a - ctrl-c - notepad - ctrl-v],
copy text from notepad to calc [notepad - ctrl-a - ctrl-c - calc - shift-ctrl-v],
in options dialog select ‘text input dialog’, and there “;” as delimiter,
(may be you get similar with [data - text to columns]),
difficulty: your data exceeds calcs sheet width, couldn’t have been all in one row,
(was the arrangement of the numbers somehow relevant?)
either split your data in chunks of max 1024 characters,
or try the ‘macro hell’,
sub split
' position (0,2) is cell A3, not tested if routine hits any size / range limitations,
Sheet = ThisComponent.CurrentController.ActiveSheet
text = sheet.getcellbyposition(0,2).string
for i = 1 to len(text)
sheet.getcellbyposition(0,2+i).value = left(text,1,1)
text = right(text,len(text)-1)
next i
end sub 'split
happy hacking …
P.S. ‘solved marks’ and ‘likes’ welcome, click the grey hook top left to the answer to turn it green if the problem is solved, click the “^” above it if you ‘like’ the answer, do not! use ‘answer’ to add info to your question, either edit the question or add a comment, ‘answer’ only if you found a solution yourself …
And you can use the Regular expressions for the F&R feature.
Seach box:
.
Means: search any character in the (selected) cell range.
Replace box:
&\t
Means: Put it back same string (character), and an additional TAB character into the cell string.
