Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COPY TO...DELIMITED bug?
Message
From
18/10/2006 18:24:54
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01163003
Message ID:
01163134
Views:
8
>I think I have come across a bug in VFP9 SP1.
>Using the COPY TO command when a field is one character long and it's empty the output file will have a space in that position but if the field is two or more characters long the position will not have the space.
>
>
>CREATE CURSOR test1 (f3 c(3),f2 c(2),f1 c(1),n1 n(1,0),n2 n(3,1))
>APPEND BLANK
>COPY TO test1.txt DELIMITED WITH "" WITH CHARACTER "|"
>
>
>Output File:
>
>|| |0|0.0
>
>
>Note that the field f1 in the output file shows a space when it should be empty like f2 and f3.
>
>Has anyone else ever ran into this before?
>
>Dennis

So what the bug is?
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform