Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Import Table, Field Value has """
Sat, Oct 18 2008 11:34 AMPermanent Link

"Jianfei Xu"
Hi,

I try to import table using Import Statement. The speed is impressive.

However, some of the Text/String Field value have " inside, then import is
not correct. How can I make sure the " get import.

example:

"ID","Name","Description","Note"
1,"J J","Test","The "Additional Note inside" should be include"


Thanks

Jianfei

Mon, Oct 20 2008 2:57 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jianfei,

<< However, some of the Text/String Field value have " inside, then import
is not correct. How can I make sure the " get import. >>

You need to make sure that they are "escaped" by adding another
double-quote, like this:

"ID","Name","Description","Note"
1,"J J","Test","The "Additional Note inside"" should be include"

--
Tim Young
Elevate Software
www.elevatesoft.com

Image