On Sep 28, 2006, at 10:45 AM, Jose Maria wrote:
Because the comma is a field delimiter, then when a field includes
it, is
delimited by " to prevent its division.
It does this in a TAB delimited file as well
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
From Thu 28 Sep 2006 13:08:50 EDT
Return-Path: <gettingstarted-bounces at lists dot realsoftware dot com>
X-Original-To: listarchive at realsoftware dot com
Delivered-To: listarchive at realsoftware dot com
Received: by xmail.realsoftware.com (Postfix, from userid 1037)
id 68623C90F93; Thu, 28 Sep 2006 10:09:16 -0700 (PDT)
X-Spam-Checker-Version: SpamAssassin 3.1.1 (2006-03-10) on realxserve.local
X-Spam-Level:
X-Spam-Status: No, score=-0.5 required=4.5 tests=AWL,NO_REAL_NAME
autolearn=disabled version=3.1.1
Received: from lists.realsoftware.com (lists.realsoftware.com [209.198.132.125])
by xmail.realsoftware.com (Postfix) with ESMTP id B444BC90F8D;
Thu, 28 Sep 2006 10:09:15 -0700 (PDT)
Received: from lists.realsoftware.com (localhost [127.0.0.1])
by lists.realsoftware.com (Postfix) with ESMTP
id D84B41533602; Thu, 28 Sep 2006 12:09:07 -0500 (CDT)
X-Original-To: gettingstarted at lists dot realsoftware dot com
Delivered-To: gettingstarted at lists dot realsoftware dot com
Received: from imo-d23.mx.aol.com (imo-d23.mx.aol.com [205.188.139.137])
by lists.realsoftware.com (Postfix) with ESMTP id A253515335EE
for <gettingstarted at lists dot realsoftware dot com>;
Thu, 28 Sep 2006 12:08:57 -0500 (CDT)
Received: from GAmoore at aol dot com
by imo-d23.mx.aol.com (mail_out_v38_r7.6.) id w.2e2.debbe4f (30739)
for <gettingstarted at lists dot realsoftware dot com>;
Thu, 28 Sep 2006 13:08:51 -0400 (EDT)
From: GAmoore at aol dot com
Message-ID: <2e2 dot debbe4f dot 324d5ba2 at aol dot com>
Date: Thu, 28 Sep 2006 13:08:50 EDT
To: gettingstarted at lists dot realsoftware dot com
MIME-Version: 1.0
X-Mailer: Thunderbird - Mac OS X sub 293
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit
X-Content-Filtered-By: Mailman/MimeDel 2.1.2
Subject: Re: text
X-BeenThere: gettingstarted at lists dot realsoftware dot com
X-Mailman-Version: 2.1.2
Precedence: list
Reply-To: Getting Started <gettingstarted at lists dot realsoftware dot com>
Sender: gettingstarted-bounces at lists dot realsoftware dot com
Errors-To: gettingstarted-bounces at lists dot realsoftware dot com
Thanks Norman and Jose. So I guess I need to write a little method to strip
the quotes off by finding out the ascii for double quotes? Or maybe something
like this... (Is there separate ascii for left quotes and right quotes?)
dim i as integer
dim s, t as string
t = "Jones, Jim"
s = ""
for i = 1 to len(t)
c = mid(t, i)
if c <>""" and c <> """ then s = s + c
next
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|