Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Psion Workabout
Message
From
14/01/1999 18:45:40
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
14/01/1999 02:45:45
Fida Shamsoodeen
Combined Systems (Pty) Ltd
Centurion, South Africa
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00173417
Message ID:
00176261
Views:
38
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform