On Fri, Dec 19, 2008 at 04:25, Rainer Schuetz <[email protected]> wrote:
> 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?). JT - I wasn't sure what other information to provide. But I'm running Openoffice 3, Base. Using the standard HSQLDB for the backend. Using GNU/Linux 2.6.24-21-generic. > I asume there is no way for you to control why you get trailing spaces and > empty lines in your data. JT - I am somewhat new to databases and self taught at that so there may be a method to control and remove trailing spaces that I'm not aware of. > 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. JT - Can I write a query that is told essentially to look for, and ignore "nothing" or "null"? I am imagining that the query would look at the whole field instead of at the last part of an entry. > > > 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". JT - I am going to look in the standard openoffice supplied help files ofr the term "string functions" to see if I can find some information on this. Thank you, John
