how clean the data when import using data port?

how clean the data when import using data port?

when i send the description of item in data port like, Description = Sony 32" Flat Screen HD Ready TV.

But it saves like this Description = “Sony 32"” Flat Screen HD ReadyTV." which is not correct.

How can i get rid of those “”.

Thnaks

Try using no field start/end delimiters, and TAB as the field separator.

I use fieldstart and end delimiter are and FeildSeparator = <,>

but it still save the same text

In your import file replace every instance of " with # then when you have imported the data do a find and replace on the table reversing this.

A developer way is:

Find and replace all " characters in your file to ~, then on your import, change the ~ character back to "

[:D] Alex - my disguise as a developer is once again ripped away to show the consultant underneath!!

Thanks it works.