Tip Bank

As explained in another item in this Tip Bank, you can use the Recordset’s GetString method to export a Recordset to a comma-delimited or tab-delimited text file. However, if you

‘ Filter out all invalid characters in a string.Function FilterString(text As String, ValidChars As String) As String Dim i As Long, result As String For i = 1 To Len(text)

Do you have problems with the spacing that HTML line breaks and paragraph tags give?Or have you ever wanted leading that was in-between the two or just a little more

Question: Is there a simple way of copying a file from one directory to another? Answer: There is no predefined convenient method for copying a file from oneplace to another.

Question: Why do I have to catch an exception when I use System.in.read()? Answer: System.in is an InputStream, and like any InputStream, an I/O errormay occur when you read from

Question: Are there any guidelines for what the directory structure of a Java-based project should be? Answer: The only real guidelines govern the layout of your source code. Yourdirectories should

Question: I’m using a catch(exception e). When I come in the catch-block and print the message belonging to the exception, I receive the message “9exception.” What does it mean? Answer:

Question: When I use onstat -d, the message “No response from server process” pops up. Then I can’t shutdown the database or do any other jobs. I could use dbaccess,

Question: Can you point me at or come up with a generic class that allows date manipulation and storage without running into OS-specific or February 29 or Y2K issues? Answer: