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!!