Hi Terry,
I have a program called TestAppend. This program appends few first records, when presents output to the user. If the user agrees, that output looks correct, when I continue. Otherwise I have to investigate...
>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
If it's not broken, fix it until it is.
My Blog