Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File to str - I need a carriage return
Message
From
15/10/2014 04:30:53
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01609388
Message ID:
01609399
Views:
41
>There is only 1 field in each record - it's a memo field - I need the text file created by file to string to have a carriage return at the end of each line
>
>So a file containing 12 records would have 12 lines in the text file each terminating with a carriage return
>
>This is an example of the memo filed in the dbf
>
>"B","4561234","10/06/2014","98.50","7220726","MERRILL CORPORATION LIMITED","CUSTOMER SERVICE","101 FINSBURY PAVEMENT 2ND FLOOR","LONDON EC2A 1ER","LONDON","","EC2A 1ER","GB","MAYER INTERNATIONAL LTD","","1 CABOT SQUARE","CANARY WHARF","INDIA","LO","E14","IN",""

o.k.
off topic: You can altter a message in UT by the Update link below the message

For your problem
SELECT yourTable
lcx = "" &&initial
SCAN FOR [expression that filters out record b]
 lcx = lcx+YourMemofield+0h0D &&I prefer the literal to the function CHR(13)
ENDSCAN
STRTOFILE(lcx,YourFileName)
This will create:
a text file,
one line per record,
line ends with CR,
empty records are empty lines,
last line ends with CR

Lutz
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform