Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
They always move the goal-posts, don't they
Message
From
05/07/2005 07:35:23
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01028919
Message ID:
01028936
Views:
14
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform