Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
File to str - I need a carriage return
Message
De
15/10/2014 04:30:53
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01609388
Message ID:
01609399
Vues:
40
>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]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform