Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy to command
Message
From
04/02/2010 17:47:24
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Copy to command
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01447652
Message ID:
01447652
Views:
101
Hello comunity

I have the following table GT , when i type this command:

use gt
copy to "c:\planogt2.txt" DELIMITED WITH _ WITH CHARACTER ';' as 1252


_ADM10012359325,029000007_;2010;__;_1411_;_Potencialmente favoráveis_;

all blank spaces are replace with underscore character.

if i use this another command :

use gt
copy to "c:\planogt2.txt" DELIMITED WITH CHARACTER ';' as 1252

the result is
"ADM10012359325,029000007";2010;"";"1411";"Potencialmente favoráveis";

all blank spaces are replace with " character.

what i need is :
ADM10012359325,029000007;2010;;1411;Potencialmente favoráveis;

Could someone give help to solve this problem.

Many thanks
Luis Santos
Next
Reply
Map
View

Click here to load this message in the networking platform