Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
They always move the goal-posts, don't they
Message
De
05/07/2005 07:35:23
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
05/07/2005 06:47:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01028919
Message ID:
01028936
Vues:
17
>Hi
>
>This is not something that I can't do, after a lot of faff, but I thought there may be a better, simpler idea out there, so I'm looking for suggestions/solution.
>
>I have an Ordnance Survey PointX text file of geographical entities, such as post offices, doctors' surgeries, etc., to import, including lat/long values. It's in the form of a delimited file, e.g.
>
>Record Type|Unique Reference Number|TOID|TOID Version|Name|...
>"L"|14357552|"1000000347714764"|3|"Constitutional Hill"|...
>
>I did the software long ago. I created an intermediate file, with fields to match the column headings in the PointX file and imported it via:
>
>Append from ( .cFacsDataFile) Delimited with " with character |
>
>All well and good but, originally, there was a telephone No. column. I've just imported some more data and found that my longtitude value was all to cock. This is because in the latest import file there is no tel. # column, so they're all "shifted along" 1
>
>Now the above append command is nice and easy and I don't want to have to write a shed load of new code to get around changes in the format of the input data.
>
>Any ideas out there, please?
>
>'ppreciate it
>
>Terry

Terry,
Let the user map fields. Check FoxyClasses sample for the ideas.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform