| View previous topic :: View next topic |
| Author |
Message |
digweed13
Newbie
Joined: 03 Aug 2006
Posts: 2
|
 Posted: Thu Aug 03, 2006 8:05 am Post subject: Open 1Gb .txt file |
 |
|
Hello,
I am trying to find a solution to open a 1Gb .txt file and have not been able to find any solution. I have looked through the support pages and have not seen anything regarding this.
Does writer have the ability to open this size file?
Thanks,
Digweed |
|
| Back to top |
|
 |
9point9
Moderator
Joined: 31 Aug 2004
Posts: 3875
Location: UK
|
| Posted: Thu Aug 03, 2006 9:52 am Post subject: |
|
|
Writer is limited to 65535 characters per paragraph. Does it break that?
What sort of text file is it? What are you trying to do with it?
_________________
Arch Linux
OOo 3.2.0
OOoSVN, change control for OOo documents:
http://sourceforge.net/projects/ooosvn/ |
|
| Back to top |
|
|
Bhikkhu Pesala
Super User
Joined: 23 Aug 2005
Posts: 2324
Location: Seven Kings, London, UK
|
| Posted: Thu Aug 03, 2006 10:00 am Post subject: |
|
|
Since it is a text file, I don't see any reason why you can split it into small pieces with a program like Chainsaw then open each piece separately.
_________________
Fonts * Opera * Oo Tips * FAQ * New Forum
Oo 2.3.1 * Win XP |
|
| Back to top |
|
|
digweed13
Newbie
Joined: 03 Aug 2006
Posts: 2
|
| Posted: Thu Aug 03, 2006 10:11 am Post subject: |
|
|
It is actually a .sql file but it is simply plain text. It is from a older database that contains information that I need access to. It can be renamed to .txt and it will still work.
I am trying to gain access to the information in the txt file without having to install mysql and then import that information (which will most likely take 2-3 days to import)
I have tried to chop it up into pieces but it ends up breaking the file and information.
Thanks,
Digweed |
|
| Back to top |
|
|
pitonyak
Administrator
Joined: 09 Mar 2004
Posts: 3618
Location: Columbus, Ohio, USA
|
| Posted: Thu Aug 03, 2006 11:39 am Post subject: |
|
|
| Quote: | | Writer is limited to 65535 characters per paragraph. |
Very interesting, I was not aware of that. I checked, and you are correct, but I was not aware of it. An entire paragraph, is therefore, always representable as a string if required; excellent.
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php |
|
| Back to top |
|
|
dfrench
Moderator
Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand
|
| Posted: Thu Aug 03, 2006 1:25 pm Post subject: |
|
|
| How about setting the text file up as an OOo data source ? You could then put the data into a real database under the control of OOo. I suspect that you will need plenty of memory for this operation though. |
|
| Back to top |
|
|
acknak
Moderator
Joined: 13 Aug 2004
Posts: 4295
Location: ~ 40°N,75°W
|
| Posted: Thu Aug 03, 2006 3:26 pm Post subject: |
|
|
What kind of access do you need? It sounds like you're bending over backwards to avoid loading it into a database.
Unix is loaded with text file utilities that just work sequentially through the file, not caring at all how big it is. You can always download a live CD and read your file from there. You can be running simple string or regex searches in a few minutes. It takes grep about 10s to run through 1.5Gb of text on my system. |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
|
| Back to top |
|
|
|
