Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't get rid of strange character in M field.
Message
De
15/03/2003 14:59:36
Donald Lowrey
Data Technology Corporation
Las Vegas, Nevada, États-Unis
 
 
À
15/03/2003 13:15:56
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00766126
Message ID:
00766223
Vues:
27
Hi Hilmar

I think I have it resolved. By hand, I have gone through the text files and identified the ASCII characters, principally 26 and 141. Instead of having a FOR..ENDFOR loop with a STRTRAN in between, I just added two lines:
lcCleanStr = CHRTRAN(lcCleanStr,CHR(26),'')
lcCleanStr = CHRTRAN(lcCleanStr,CHR(141),'')

Also, this is an operation that runs for a considerable period of time. On customer locations with really large numbers of text files, it could take hours. The table involved is never closed until the operation is complete. If a table remains open, I read somewhere that Fox only actually writes to disk at certain intervals (something like once every five minutes). I have been interrupting the program after a few hundred records. I may have interrupted the operation before an actual physical write to disk, thereby getting the memo from the previous overwrite. In a Belt and Suspenders move, I also added a FLUSH every 1000 records.

This seems to work fine. Thank you for your assistance.

Don Lowrey
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform