Hi John,
for very specific help the info you provide doesn't look detailed
enough. Are u using Base's internal database or an external db-backend
(mysql, postgresql?).
I asume there is no way for you to control why you get trailing spaces
and empty lines in your data. So what I would try is create a view or
a query that filters the unwanted characters out of your raw data
(sort of a parser). Rather than reading the table directly you would
read the filtered data from the query.
Depending on your database, removing trailing spaces can be very
simple: in postgres, e.g., you can retrieve a column by
'rtrim(fieldname)' rather than just 'fieldname' and trailing spaces
will be gone. In Postgres you can even define which character or set
of characters should be removed from the end of the field. Removing
empty lines can be a bit tricky, because empty lines could be
linefeed, carriage return or both, and it might not be trivial to
address them (maybe with '\n' or something). Most databases offer
similar functions. You would have to find the options you have in the
documentation of the database backend you use. Usually you would find
them in a chapter headed "string functions".
Best
Rainer
On 19.12.2008, at 07:27, John Toliver wrote:
I use a database to enter my research on various pathophysiology. I
enter
my data in a table with about 12 fields. The data format of most of
the
data fields is memo (longvarchar). What I then do is this: when I'm
working in a writer page, and I press "f4>navigate to database>select
table>select record>insert record. The problem I have is the text
in each
field may be one paragraph or two or more. So the number of
characters is
always different (which is why I use memo instead of a set text
limit).
What happens is it will insert all the contents of the field
including the
trailing spaces(which I don't want) at the end of the text for each
field in
the record. I want it to look like a normal document with various
paragraphs and instead I usually get the paragraph, then two blank
pages of
carriage returns then the next field of the record so a document
that should
be 1-2 pages in length becomes 32 most of which is carriage returns
down the
page.
How do I keep the blank space at the end of the entry from being
inserted
with the rest of the record?
Any help is appreciated.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
