Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Psion Workabout
Message
De
14/01/1999 18:45:40
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
À
14/01/1999 02:45:45
Fida Shamsoodeen
Combined Systems (Pty) Ltd
Centurion, Afrique du Sud
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00173417
Message ID:
00176261
Vues:
39
>Hi Dragan
>
>Thank you so much for your reply.
>I have no problem coding for the psion or linking the problem
>is that when i send a file to the pc it is in an unreadable format.
>I have program that is called dbconvert which converts the file
>to a flat text file. The problem comes when i append it to a
>vfp table. The first field is fine, but from there onwards the
>fields all have a /t in front of the field which in vfp table
>look like this -> "|".
>
>got any suggestions as to get rid of this pipe sign?

You got several options, one of them being to play with Psion's utilities - I seem to remember that there was some better format to export to. If you don't find that, here's couple of ways you can do it:

Make an intermediate table with one single character field, wide enough to take the whole line from the text file, append to that first. Then
Copy [field name here] to tempfile.txt sdf
select real_table
append from tempfile type delimited with character |

Or you may just go for low-level file functions. Actually, you may append the first text file into a memo field, replace all \t's with chr(9) and dump them out back into another text file, and then append from it ...Type delimited with tab.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform