I'm using V4RB, but this is a general kernel question. I'm creating a cursor
to import text to. This is a simple, two field database consisting of a name
and e-mail address.
This is my SQL for the cursor:
SELECT realname,email from Person
Then I run importtext off the cursor on my tab delimited file and it works
fine.
However... the text is also qualified by double quotes ("). So when the data
makes it in, each field has quotes as a prefix and suffix. I figured I could
modify my import cursor like this:
SELECT replace(realname,'"',''),replace(email,'"','') from Person
But, that didn't work. It just kept it from importing any records at all.
Any ideas? Anyone ever run into this issue before?
Best Regards,
--
Paul Scandariato
Intelli Innovations, Inc.
http://www.intellisw.com/
E-mail: paul (AT) intellisw .DO.T com
It is impossible to get anywhere
without sinning against reason.
- Albert Einstein
©2001 Paul Scandariato |
