|
AJ,
I have recently been doing a large amount of data import into Rbase
from CSV files and have encountered many problems due to strange
characters in the imported data. I have had success reviewing the
data in MS Excel which has shown me exactly where the unprintable
charaters are. I can then make the necessary corrections in
Excel to these columns and save.
If you encounter a lot of unprintable characters this could be a slow
process.
Hope this helps.
Richard (Ringo) Starkey
-------Original Message-------
Date: Tuesday, August
20, 2002 7:36:24 PM
Subject: RBWIN65 -
identifying non-printable characters in text fields
Can anyone tell me an easy way to determine if text
fields in my database
(i.e. name and address lines) contain
non-printable characters that may
have come from a mainframe import
without being properly scrubbed?
I'm printing checks to a PDF file
using the rbase report writer, and then
printing the PDF file to the
laser printer for laser checks. I've got a
database where everything is
fine until now and then the alignment jumps by
a line or two (kind of a
bad thing when you're printing to pre-printed
check forms!).
I'm
just guessing it may be some bad data in the name and address
lines
that I can't see, but I don't know how to identify it and clean
it up if
that is in fact the problem.
Any help will be greatly
appreciated.
thanks,
aj
-----------------
NOTE: NEW AREA CODE FOR SOUTH BEND, INDIANA AS OF
06/14/2002
-----------------
Allan D. Jean
Crowe, Chizek and Company LLP
330
East Jefferson Blvd., P.O. Box 7, South Bend, IN 46601
Office: Main
(574) 232-3992, Direct (574) 236-7670, FAX (574) 236-7606
Home: (574)
231-1401, Home FAX (574) 231-1402
email: [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This
message may contain privileged or confidential information. If you
are
not the intended recipient of this message, you may not make any
use
of, or rely in any way on, this information, and you should destroy
this
message and notify the sender by reply email. Any opinions or
advice
contained in this email are subject to the terms and conditions
in any
applicable client engagement letter or service
agreement.
================================================
TO
SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In
the message body, put just two words: INTRO
rbase-l
================================================
TO
UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In
the message body, put just two words: UNSUBSCRIBE
rbase-l
================================================
TO SEARCH
ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
. | 