* Eike Rathke <[EMAIL PROTECTED]> <
> [2005-03-17]:
> Hi Ennio-Sr,
>
> On Sat, Mar 12, 2005 at 18:47:38 +0100, Ennio-Sr wrote:
>
> > What happens, in effect, is that the original web-site .....
> > ....
>
> ..... But this is all guessing around now. If choosing the space
> separator like mentioned blow doesn't help, you might consider to upload
> your document(s) somewhere and give us an URL so that we can access it
> and have a look.
>
I'd do that very willingly, however I don't have the capabilities to
enable my reserved web space with my DSL provider ;( (with so many kids
around sending worms, virus and similar stuff I need managing security
firewalls first) [But see below]
[...]
> > > 'prepare' said .txt file with some text-utils (like sed, tr) and noticed
> > > that if I search for Tabs nothing changes;
>
> So it is not tab delimited.
>
It's not me but Calc that selects the Tab delimited item when showing
the dialog box ... ;)
> > > if the search/substitution is
> > > made on single space, the substitution occurs as many times as the
> > > spaces involved (not always the same ;) ).
>
> Normal.
>
> > I'm not an expert to judge whether this occurs as a consequence of how
> > the web site is organized, or of the kind of treatment (presumably)
> > reserved to it by the browser downloading it as a .txt file. I can
> > imagine that the web-site is w$ 'oriented', if this may matter.
^^^^^^^^^^^^^^^^^^^^^^^^
That assumption is not valid: I checked that the same happens with Lotus ME!
> > Hexedit-ing the downloaded .txt file I can see no Tab chars in it, but
> > only spaces (char 0x20). [*]
>
> Then select the space as separator, and maybe check the "merge
> delimiters" option.
>
I tried "merge delimiters": it gets columns right (in the sense that
they become 'real' cells, not rows) but the cell contents is no longer
aligned. Let me explain better with a short example (where each point
represents a space):
File.txt:
First line ends here.........***..10,15..-0,15..12,30..Mar 17 05..
Second line .................***.200,02..+1,30..33,50..Mar 17 05..
will appear in Calc:
First line ends here.........***..10,15..-0,15..12,30..Mar 17 05..
Second line....***.200,02..+1,30..33,50..Mar 17 05..
BTW, at this point it's only an 'academic' discussion, hoping it helps
getting a better response from OOo-Calc. AAMOF I did manage to avoid
that 'treating' the original text with a script that sets things right
inserting a 'pipe' (|) delimiter
Regards,
Ennio
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (�|�)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
