Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't get rid of strange character in M field.
Message
From
15/03/2003 14:59:36
Donald Lowrey
Data Technology Corporation
Las Vegas, Nevada, United States
 
 
To
15/03/2003 13:15:56
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00766126
Message ID:
00766223
Views:
28
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform