>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.